View Single Post
  #4   Report Post  
Dana DeLouis
 
Posts: n/a
Default

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?