One way...

Create this defined name...
Goto the menu InsertNameDefine
Name: SheetNames
Refers to: =GET.WORKBOOK(1)&T(NOW())
OK

Then, to get the count of worksheets:

=COUNTA(INDEX(SheetNames,0))

--
Biff
Microsoft Excel MVP


"booshi" wrote in message
...
How to put the total number of sheets in a work cell?
Thanks