Description: Finds the number of the row(s) corresponding to reference.

Arguments:

Name	Type	Description
reference	reference to a single cell or to a range of contiguous cells	If omitted, the behavior is as if reference referred to the cell containing the formula.

Return Type and Value: number – If reference refers to a single cell or to a single row of cells, the corresponding row is returned. If reference refers to a range of cells involving multiple rows, a vertical array of the corresponding rows as numbers is returned.

However, if the range of cells referred to by reference is not contiguous, #REF! is returned.

[Example:

ROW() results in 16, when the cell containing the formula is in row 16
ROW(E17:G17) results in 17
ROW(E16:G17) results in a vertical array containing 16 and 17, respectively

end example]