How can you find how many worksheets in a workbook?

G

Guest

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?
 
G

Guest

Open the VB editor, then open Project Explorer, all the tabs will be neatly
listed
 
D

Dana DeLouis

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
 
G

Guest

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.
 

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

How many worksheets can you have in one workbook? 9
How many total worksheets can be added to a workbook? 4
Trace links between worksheets within one workbook 4
merging and mailing multiple worksheets 1
Clustering worksheets 1
Set the print order of worksheets when printing entire workbook 2
Special Pasting a work book with many sheets and formulas 2
Combine Several Worksheets within a Workbook 1

Top