How to count number of worksheets in an Excel file

excel vba

← Prev

Tools you can use

You can use the SHEETS() function in Excel to find the total number of worksheets in an Excel file. Alternatively, you can use a simple macro to get the total count (or number) of sheets.

Count total sheets using a formula

You can use this built-in function to get the total number of sheets in your workbook.

=SHEETS()

Simply enter the =SHEETS() function in any cell and press the "Enter" key. Do not assign any argument (or parameter) to the function. It will "return" the total number of sheets in the Excel file (or workbook), including hidden sheets.

Also read... What is the formula in Excel to get the SUM of unique values?

Count sheets in Excel using VBA

Write this code in a module and press F5.

Sub sheetCount()
    Debug.Print (Sheets.Count)   ' Press Ctrl + g to open the debug window and see the output.
End Sub

Related post... How to count total number of Words in a cell or range in Excel using VBA?

← Previous