Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I compare data in two worksheets to find matching cells? | Excel Discussion (Misc queries) | |||
How to search multiple worksheets in a workbook for information? | Excel Discussion (Misc queries) | |||
Viewing Worksheets withing One Workbook | New Users to Excel | |||
find links to another workbook | Excel Discussion (Misc queries) | |||
Removing links to other worksheets from within a workbook | Excel Discussion (Misc queries) |