The Excel Sheets function returns the number of sheets in a supplied reference. The result includes sheets that are Visible, Hidden or Very Hidden.
Note: the Sheets function was first introduced in Excel 2013 and so is not available in earlier versions of Excel.
The syntax of the function is:
Where the supplied [reference] argument is a reference for which you want to know the number of sheets. This is an optional argument which, if omitted, defaults to the current workbook.
The spreadsheets below show examples of the Excel Sheets function used in an Excel workbook that contains 3 sheets.
Further examples of the Excel Sheets function can be viewed on the Microsoft Office website.