Counting number of worksheets in a Excel 2007

  • Thread starter Thread starter Y D
  • Start date Start date
Y

Y D

Dear Sir,
I am using MS office 2007, and want to know what is command/formula to count
the number of worksheets in a Excel.
I deals with some taxation matter wherein I need to have hundreds of sheets
in a file.

Thank in advance.
 
From within Excel code, Worksheets.Count will return the number of
worksheets in the workbook.
 
Back
Top