EXCEL GET RANGE

From Macros Wiki
Jump to: navigation, search

Up

Command

EXCEL_GET_RANGE <range number>, <row 1>, <col 1>, <row 2>, <col 2>


Get a range of cells from the currently open excel document for use with a dropdown menu.

Parameters

<range number>
Range number (1 to 10).
<row 1>
Start row number
<col 1>
Start column number
<row 2>
End row number
<col 2>
End column number

Example

EXCEL_GET_RANGE 2, 2, 2, 6, 5
Note. The range must be 1 dimensional. Either the same start and end row, or the same start and end column.