EXCEL GET RANGE

From Macros Wiki
Revision as of 12:51, 12 January 2011 by Mikeo (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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.