SHEETNAME (name of a worksheet)

<< Click to Display Table of Contents >>

SHEETNAME (name of a worksheet)

Syntax:

SHEETNAME([n])

Description:

This 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 does not exist in Microsoft Excel. If you save a document in Excel format, all calculations using this function will be replaced with their current result as a fixed value.

See also:

SHEET, SHEETS, FILENAME