Function to get the sheet number.
Sequential numbers starting from 1 from the left.
This function has limited use.
Its primary use is to check a worksheet by number when you want to access it from an external program by number.
How it works
=SHEET(value)
| Argument | Omission | Explanation |
|---|---|---|
| value | Sheet of cells in which formulas exist. | Specify the target to get the number. Cell address: Sheet on which the specified cell exists. String: Sheet name. |
Example Results
If the argument is omitted, the sheet number of the cell in which the function was entered is retrieved.
If you rearrange the sheets, the numbers will also change.
With the arguments.
If it is text, treat it as a sheet name.
In the case of a cell reference, the sheet number of the cell reference is obtained instead of the value of that cell.
---