PowerUp Description
The pwrSHEETNAME function returns the name of the current worksheet.
PowerUp Syntax
pwrSHEETNAME()
The pwrSHEETNAME function has the following arguments:
none
Return Value
The pwrSHEETNAME function returns the name of the current worksheet.
Remarks
If the name of the sheet changes after the formula is entered the evaluated name will not change.
If you get the name of a specific sheet number and that sheet is moved or deleted the evaluated name will not change.
If you enter the number of a sheet that does not exist, the #VALUE! error will be returned.
Examples
=pwrSHEETNAME()
Will return the current worksheet’s name.
=pwrSHEETNAME(2)
Will return the second worksheet’s name.
