WorksheetName and WorksheetsNo UDFs

Once you open the sheet and enable macros, you can use function: =WorksheetsNo() To get total number of sheets in that workbook And use function: =WorksheetName(1) To get sheet name …