PowerUp Description
The pwrSHEETNAME function returns the name of the current worksheet.
PowerUp Syntax
pwrSHEETNAMES([ReturnVertical])
The pwrSHEETNAMES function has the following arguments:
ReturnVertical – Optional. True to return the list of tabs vertically. False to return the list of tabs horizontally. The default value is False.
Return Value
The pwrSHEETNAMES function returns the name of the worksheets in the current workbook.
Remarks
In Excel 2010, you need to enter as an array formula in order to get all results.
In the current version of Excel, you do not need to enter as an array formula. Excel will extend across cells and return a #SPILL! error if the array returns information that would overlap with other data already in your sheet.
Examples
=pwrSHEETNAMES()
Will return the current worksheet’s names in horizontally.
