|
COUNTUSEDCOLS2 Function
The COUNTUSEDCOLS2 function counts the number of columns across right to the end of the used range for this sheet.
COUNTUSEDCOLS2 Syntax
COUNTUSEDCOLS2 (theColumn)
TheColumn
A range reference to a cell in a column.
COUNTUSEDCOLS2 counts the number of columns, including blanks and empty cells across right to the end of the used range for the sheet containing theColumn.
The count includes the leftmost column of the referenced range.
COUNTUSEDCOLS2 Remarks
COUNTUSEDCOLS2 is a volatile function.
If the reference specified for theColumn contains more than one column, the leftmost row will be used.
The used range may contain empty rows or columns.
Whenever the COUNTUSEDCOLS2 function is calculated the used range for the worksheet containing theColumn will be reset.
COUNTUSEDCOLS2 Example
Assuming that cell C55 contains 10 and cell Z100 is empty but coloured yellow, and no other cells have been formatted then:
=COUNTUSEDCOLS2(C4) returns 24 (column Z is the last column (26) in the used range less columns A and B).
|
