<< Click to Display Table of Contents >> SHEETNAME (name of a worksheet) |
Syntax:
SHEETNAME([n])
Description:
Returns the name of a worksheet.
n is the number of the worksheet whose name you want to determine. The first worksheet in the workbook is number 1, the second is number 2, etc. If n is omitted, the current worksheet is used.
Example:
A document contains four worksheets: "Spring", "Summer", "Autumn" and "Winter" (in that order). The cursor is currently located in a cell of the third worksheet ("Autumn"). The following applies:
SHEETNAME() returns Autumn
SHEETNAME(1) returns Spring
Compatibility notes:
This function is not supported by Microsoft Excel. If you save a document in Excel format, all calculations using this function will be replaced by their last result as a fixed value.
See also: