Counting number of worksheets in a Excel 2007
 

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.

Counting number of worksheets in a Excel 2007
 

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

--
Rick (MVP - Excel)


"Y D" <Y wrote in message
...
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.