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.