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() =SHEETS(MySheet!A1:C5)

See Also

Function Reference
COLUMNS Function
ROWS Function
SHEET Function