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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Found few bugs in my daily routine of work in excel for MAC 0
Syncing between source worksheet and dependent worksheets 0
Found few bugs in my daily routine of work in excel for MAC 0
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Excel - Wich Function should I use? 1
Setting language of a selected text in Office apps. 0
Counting # of entries for each month, in a specific status 3

Top