Number of Sheets in a workbook formula
 

Is there a formula that will return the number of sheets in a workbook?

Thanks.

Number of Sheets in a workbook formula
 

One way is to put this function in a standard module, then in any cell of
any sheet type "=NumShts()" without the quotes. HTH Otto
Function NumShts()
NumShts = Sheets.Count
End Function
"PCLIVE" wrote in message
...
Is there a formula that will return the number of sheets in a workbook?

Thanks.

Number of Sheets in a workbook formula
 

Thanks Otto,

I already knew this way, but I was trying to avoid vba for this workbook.

Anyway, it's been awhile since I posted this question (awhile today). I
found another way to do what I needed.
Thanks anyway.

"Otto Moehrbach" wrote in message
...
One way is to put this function in a standard module, then in any cell of
any sheet type "=NumShts()" without the quotes. HTH Otto
Function NumShts()
NumShts = Sheets.Count
End Function
"PCLIVE" wrote in message
...
Is there a formula that will return the number of sheets in a workbook?

Thanks.