| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Threaded Mode
