Returns the sheet number of the referenced sheet.

value(Optional) The name of a sheet or formula reference.

* If "value" is not provided, then the number of the active sheet is returned.
* This function includes all worksheets (visible, hidden, very hidden, chart, dialog sheets, macro sheets).
* This function cannot be called from VBA.
* If "value" is not valid, then #REF is returned.
* You can use the INFO function to return the text string returning useful information about the environment.
* You can use the SHEETS function to return the number of sheets in a reference.
* This function was added in Excel 2013.
* For the Microsoft documentation refer to

1=SHEET() = 3
2=SHEET("Sheet1") = 1
3=SHEET("Sheet3") = 3
4=SHEET("Sheet5") = 5

1 - The sheet number of the active worksheet.

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top