Sheet() and Sheets()
August 22, 2018
Getting total number of sheets (Sheets), or ID of this sheet (Sheet). The two new formulas Sheet() and Sheets() can do well, yes not perfect, we still need to have function to list sheet names, but it is a start
Sheets() function will get you total number of sheets (in this workbook or certain workbook)
While Sheet will only return the ID of this sheet among sheets in this workbook
About The Author
ANmar
An Excel-Passionate user, developer and teacher Love finding new ways to solve daily issues and enhances to regular users, then teach that