EXCEL FIND CELL: Difference between revisions

Latest revision as of 17:39, 12 January 2011

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

Find a cell in a given range or cells.

<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.

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

@@ Line 9: / Line 9: @@
 |param4=<col 2>|param4_desc={{col 2}}
 |param5=<cell text>|param5_desc=The text to search for. The contents of the cell must match this text.
-|param6=<row>|param6_desc={{var name}} for the row number
+|param6=<row>|param6_desc={{parameter_variable_any_name}} the row number.
-|param7=<col>|param7_desc={{var name}} for the column number
+|param7=<col>|param7_desc={{parameter_variable_any_name}} the column number.
 }}