How can you find how many worksheets in a workbook?
 

We have a really big project going on with a lot of seperate worksheets in
one workbook. Is there a quick way to find out how many 'tabs' are in the
book?

In the VBE immediate window

?Activeworkbook.Worksheets.Count

--
HTH

Bob Phillips

"JonM4" wrote in message
...
We have a really big project going on with a lot of seperate worksheets in
one workbook. Is there a quick way to find out how many 'tabs' are in the
book?

Open the VB editor, then open Project Explorer, all the tabs will be neatly
listed
--
Gary's Student


"JonM4" wrote:

We have a really big project going on with a lot of seperate worksheets in
one workbook. Is there a quick way to find out how many 'tabs' are in the
book?

Just throwing this idea out as it's not the best vs. the vba solution of
"Activeworkbook.Worksheets.Count"

Before you open your "Big" workbook, note the number of open sheets with the
worksheet function:
=INFO("numfile").

Say there are "x" number of open sheets.

Then after you open your project, have a cell with
=INFO("numfile") - x

HTH
--
Dana DeLouis
Win XP & Office 2003


"JonM4" wrote in message
...
We have a really big project going on with a lot of seperate worksheets in
one workbook. Is there a quick way to find out how many 'tabs' are in the
book?

This worked out great. Of course EXCEL and VB sort into 1s, 2s etc rather
than sequential numbering...but it STILL is quicker than clicking each sheet
or going to Properties and tallying the contents!

Thanks to you, Bob and Dana for posting.

"JonM4" wrote:

We have a really big project going on with a lot of seperate worksheets in
one workbook. Is there a quick way to find out how many 'tabs' are in the
book?