Excel Range

From AutoIt Wiki
Revision as of 15:33, 31 October 2014 by Rt01 (talk | contribs)
Jump to navigation Jump to search

On this page you will find some special ranges and how to define them in AutoIt.
As input file I will use the following Excel workbook. All cells which have a value now or had a value before (means: all cells which had been touched by the user or a script) are displayed in grey.

All examples show cells of the selected range in yellow.

Used Range

$oRange = $oWorkBook.Activesheet.UsedRange

Selects all cells which have a value now or had a value before (means: all cells which had been touched by the user or a script).
Note that the range does not contain row 1 and column 1!