Article Details
Id:14539
Product:finPOWER Connect
Type:NEW
Version:3.00.06
Opened:05/05/2017
Closed:05/05/2017
Released:29/06/2017
Job: J018953

Excel Workbook functions; add new function to get Cell by Named Range

Added a new Excel Workbook function to get the top/ left cell of a Named Range.

The new function is ISWorksheet.CellByNamedRange("") and returns an ISExcelCell object - or Nothing if the Named Range is invalid.

Note, currently Named Ranges are limited to a single cell or simple cell range and not a series of cell ranges.