How to do sheets.count by worksheet function? Thanks
F Frank Kabel Feb 16, 2004 #3 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
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
