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.