Home Excel Powerpoint Word Outlook Error Codes

VBA Useful Codes

Welcome to the World of VBA
Home > VBAUsefulCodes

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

Enter your e-mail below and get notified on the latest blog posts.




Tags

VBA Outlook KPI Excel Alt+F11 Dashboards Macros Recording Graphs Automation Developer WaterFall Powerpoint Charts Pivot Tables Forecast Charts


Follow Us