EXCEL GET RANGE
From Macros Wiki
Jump to navigationJump to search
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.