WorksheetName and WorksheetsNo UDFs February 7, 2012 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:... Posts navigation 1 2 3