Mega Code Archive

 
Categories / VisualBasic Script / Excel
 

Get Worksheets count in a Workbook

Sub getSheetCount()     MsgBox ThisWorkbook.Worksheets.Count End Sub