Home > VBAUsefulCodes
If you ever need to count the number of sheets in a workbook, use the VBA command: Application.Sheets.Count
Count the Sheets in a Workbook
If you ever need to count the number of sheets in a workbook, use the VBA command: Application.Sheets.Count
Public Sub CountMySheets()
MsgBox Application.Sheets.Count
End Sub
Subscribe
More to Explore
Tags
VBA Outlook KPI Excel Alt+F11 Dashboards Macros Recording Graphs Automation Developer WaterFall Powerpoint Charts Pivot Tables Forecast Charts