Video

Excel 2007, determine count of worksheets in a spreadsheet

If you need to know how many worksheets in a spreadsheet.

Dim sheetCounter as Integer
sheetCounter = ThisWorkbook.Worksheets.Count

Advertisements