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

Excel 2007 - worksheets macro 1
COUNTIF across a number of worksheets 1
counting periods Excel 1
Find value in more than 100 worksheets at once 2
using the =page! feature to transpose a row to column 0
Excel Count If Formula Question 1
Counting the number of times a character occurs in a cell 1
COUNTIF not counting properly 2

Top