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