Returns the sheet number of the specified cell reference or sheet name.
Syntax
 Copy Code
|
|---|
SHEET( [ReferenceOrText r] ) → Integer |
Parameters
- r
- Required. The name of a sheet or a cell reference for which to returns the sheet number.
Remarks
If the value of the specified argument is not a valid cell reference or is a partial cell reference, the function returns the #REF! error value. If the argument is text and there is no sheet or named range with this name, the result is #N/A. If r is omitted, the function returns the sheet number of the current sheet.
Example
| Formula
Copy Code
|
|---|
=SHEET() |
See Also
Function Reference
COLUMN Function
ROW Function
SHEETS Function