<< Click to Display Table of Contents >> Navigation:  Macros > Macro commands and parameters > Macro reporting commands > Macro write to Excel > Macrocommando GetUsedRange

Purpose:

Retrieve the range of a worksheet in the workbook under FileIndex, via four variables.

 

General notation:

GetUsedRange ( FileIndex, sheet number, first row variable, first column variable, late row variable, late column variable )

 

FileIndex is the index that refers to the workbook file opened using Open.

FileIndex 0 is the default output workbook.