number of worksheets

[booshi]

How to do sheets.count by worksheet function?
Thanks

 

[Vasant Nanavati]

I may be wrong, but I don't think you can.

 

[Frank Kabel]

Hi
AFAIK you'll need a UDF for this. e.g. try something like the following
Public Function count_sheets() As Integer
Application.Volatile
count_sheets = Sheets.Count
End Function

and enter =count_sheets() in one of your cells