Thread: Count number of sheets
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Count number of sheets
On my computer, about 5447 sheets.

This UDF give the number of sheets:

Function SheetCount() As Integer
Application.Volatile
SheetCount = Sheets.Count
End Function

--
Gary''s Student - gsnu200742


"JHL" wrote:

Hello,
I have two questions. What is the limit on the number of sheets in a Excel
file? How can I count the number of sheets in a large worksheet?

Thanks,
JHL
Reply With QuoteReply With Quote