|
COUNTUSEDROWS2 Function
The COUNTUSEDROWS2 function counts the number of rows down to the end of the used range for this sheet.
COUNTUSEDROWS2 Syntax
COUNTUSEDROWS2 (theRow)
TheRow
A range reference to a row.
COUNTUSEDROWS2 counts the number of rows, including blanks and empty cells down to the end of the used range for the sheet containing theRow.
The count includes the top row of the referenced range.
COUNTUSEDROWS2 Remarks
COUNTUSEDROWS2 is a volatile function.
If the reference specified for theRow contains more than one row, the top row will be used.
The used range may contain empty rows or columns.
Whenever the COUNTUSEDROWS2 function is calculated the used range for the worksheet containing theRow will be reset.
COUNTUSEDROWS2 Example
Assuming that cell B55 contains 10 and cell Z75 is empty but coloured yellow , and no other cells have been formatted then:
=COUNTUSEDROWS2(B4) returns 72 (row 75 is the last row in the used range less rows 1-3).
|
