Home > VBAUsefulCodes
Displays the count of no of worksheets in a workbook.It will be useful when you performing calculations based on sheets
Number of Worksheets in a Workbook
Displays the count of no of worksheets in a workbook.It will be useful when you performing calculations based on sheets
Sub MySheetCount()
Dim myCount As Long
myCount = Application.Sheets.Count
MsgBox myCount
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