Lori,
Shouldn't that formula:

=counta('*'!a1)+1

be accompanied with a caveat that there's a bug in XL02 where that formula
*might* cause a crash, and/or a mis-calculation?

Don't know what it does in XL03 and XL07.

Does work fine in XL97.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Lori" wrote in message
...
Another way - from the menus choose...

help about Excel system info office apps Excel active workbook

this lists sheet count and names. (Copy by ctrl-clicking items.)

Or... similar to the formula above, enter in any cell: =counta('*'!a1)+1
[since the '*' evaluates to all sheets other than the active one.]

"Willie" wrote:

How can I count the number of worksheets in a workbook?