There is no built-in function to do this. You must use VBA.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Vincdc" wrote in message
...
Thanks!
Just be curious, is there any built-in formula or function for
this one? I
mean not the VBA code.


"Bob Phillips" wrote:

with VBA

Function WSNum()
WSNum = Activeworkbook.Worksheets.Count
End Function

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Vincdc" wrote in message
...
Hello:
Is there any function or other method to count the number of
worksheets in
a
workbook? I have a workbook which includes dozens of
worksheets (each for
one
client) and I would like to know the total number of
clients.
Thanks in advance!