If you need to know how many worksheets in a spreadsheet.
Dim sheetCounter as Integer
sheetCounter = ThisWorkbook.Worksheets.Count
If you need to know how many worksheets in a spreadsheet.
Dim sheetCounter as Integer
sheetCounter = ThisWorkbook.Worksheets.Count