| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop through sheets and get number of records per sheet
Hi all, i have a variable number of sheets in a workbook, with variable rows
of data in each sheet. Each sheet has a specific name. I need to loop through all sheets and get the number of rows per sheet and store the number of rows per sheet/name on a summary sheet. e.g. George 20 Les 150 Johan 60 Any help is as per normal much appreciated -- Les |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Loop through sheets & filter main sheet using sheet name | Excel Programming | |||
| Loop to Filter, Name Sheets. If Blank, Exit Loop | Excel Programming | |||
| Number of Sheets (Full of Sheet) | Excel Discussion (Misc queries) | |||
| How to know the total number of records in the excel sheet | Excel Programming | |||
| Loop across Sheets and number of sheets | Excel Programming | |||
Threaded Mode
