Counting number of worksheets in a Excel 2007

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.
 
R

Rick Rothstein

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