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.