Thread: Count number of sheets
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
JHL JHL is offline
external usenet poster
  
Posts: 56
Default Count number of sheets
Thank you Gary and Bernard

"Gary''s Student" wrote:

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