ROW(ref)

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:

Other lookup functions