EXCEL FIND CELL

From Macros Wiki
Jump to: navigation, search

Up

Command

EXCEL_FIND_CELL <row 1> <col 1> <row 2> <col 2> <cell text> <row> <col>


Find a cell in a given range or cells.

Parameters

<row 1>
Start row number
<col 1>
Start column number
<row 2>
End row number
<col 2>
End column number
<cell text>
The text to search for. The contents of the cell must match this text.
<row>
Name of variable to be set to the row number.
<col>
Name of variable to be set to the column number.

Example

EXCEL_FIND_CELL 2, 2, 4, 6, "MyCell", r1, c1