View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

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?