Returns the name
of a specified sheet in the current workbook.
- the index number of the sheet (in the current workbook) to be considered.
For example, the first sheet (count from the left) is 1, and so on.
You can specify
a cell (cell reference) that contains a number, a logical values, or text
representations of numbers. Cells that contain error values or text that cannot
be translated into numbers cause errors.
be larger than or equal to zero.
is not a whole number, then it is rounded to the nearest integer.
is 0 (zero), SHEETNAME returns the name of the current worksheet.
is larger than the total number of sheets in the current workbook, SHEETNAME
returns a #VALUE! error.