Returns the number of sheets in the specified cell reference.
Syntax
 Copy Code
|
|---|
FUNC( [Reference r] ) → Integer |
Parameters
- r
- Optional. A reference to a range of cells for which to return the number of sheets.
Remarks
If the value of the specified argument is not a valid cell reference, the function returns the #REF! error value. If r is omitted, the function returns the number of sheets in the current workbook.
Example
| Formula
Copy Code
|
|---|
=SHEETS() |
See Also
Function Reference
COLUMNS Function
ROWS Function
SHEET Function