| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet with most rows
I have a workbook containing 100+ sheets. Is it possible to find
which sheet has the most rows? The data columns in these sheets contain dates, coin grades and prices. I have created an Sheet Index (using ASAP) and would like to add the number of rows each sheet has to the appropriate cell in the Sheet Index. Is this possible? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy rows from one worksheet automatically, ignore rows that are b | Excel Worksheet Functions | |||
| instering rows in one worksheet that reflect another worksheet | Excel Worksheet Functions | |||
| insert rows in a worksheet that do not change adjoining rows | Excel Discussion (Misc queries) | |||
| How do I insert blank rows between rows in completed worksheet? | Excel Discussion (Misc queries) | |||
| Why does rngDataSource.Rows.Count = 65536 when worksheet Rows=95? | Excel Discussion (Misc queries) | |||
Threaded Mode
