SHEET

Returns the sheet number of the specified cell reference or sheet name.

Syntax

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

=SHEET()
=SHEET(Sheet1!A1)

See Also

Function Reference
COLUMN Function
ROW Function
SHEETS Function