Article Details
Id: | 14568 |
Product: | finPOWER Connect |
Type: | NEW |
Version: | 3.00.06 |
Opened: | 12/05/2017 |
Closed: | 15/05/2017 |
Released: | 29/06/2017 |
Job: | J019017 |
Excel Worksheet; new function added to return information about the Used Range
A new Excel Worksheet function has been added to return information about the Used Range of Cells in a Worksheet.
The new function is "GetUsedRangeInformation" and returns the start and end Cell References.
Note, there is also an option to ignore Cells that have no value, the default is to include them.