Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
In XL2003 and XL2007: Limited by available memory (default is 3 sheets)
You find this by searching Help with the term "specs" This UDF will tell you how many worksheets (excludes chartsheets): Function Sheetcount() Sheetcount = Worksheets.Count End Function Call it with =SHEETCOUNT() Need help with VBA: see David McRitchie's site on "getting started" with VBA http://www.mvps.org/dmcritchie/excel/getstarted.htm There is also =INFO("numfile") but I am not sure what value it really gives! best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "JHL" wrote in message ... 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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I count number of sheets present in a workbook? | Excel Discussion (Misc queries) | |||
Count rows and insert number to count them. | Excel Discussion (Misc queries) | |||
count each cell that have a number and take that number and count. | Excel Discussion (Misc queries) | |||
Count the number of sheets. | Excel Discussion (Misc queries) | |||
Number count - postcodes and need to count the numbers of tim... | Excel Discussion (Misc queries) |