VBA: Count the sheets in a Workbook

August 14th, 2004 | Categories: Worksheets | Tags: , ,

If you ever need to count the number of sheets in a workbook, use Application.Sheets.Count

Put this in a module:

Public Sub CountMySheets()
MsgBox Application.Sheets.Count
End Sub
Leave a comment | Trackback
No comments yet.