The ROW function returns the row number of ref, according to the following:
ref |
returns |
cell |
row number |
range |
number of topmost row in a range |
omitted |
current row number |
For example:
ROW(Z100) |
returns 100 |
ROW(D5..G10) |
returns 5 |
ROW(mycell) |
returns the row number of a named cell, mycell, or the topmost row within mycell if it is a range |
ROW( ) |
returns 5 if the function is entered in any cell in row 5 |
See also: