| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete every other line in LARGE worksheet
Can anyone think of a FAST way to delete every other line in a 45,000
line worksheet? I can do a loop with Range("A"&Loop).EntireRow.Delete, but it takes almost 10 minutes. I was thinking of somehow selecting every other line and doing one HUGE delete, but not sure if Excel could handle that or if it would be any faster. Any ideas?!! Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Challenge - Excel Line Feed Character CHR(10) - How to Delete and keep the text formatting without going ro single line in a cell ? | Excel Worksheet Functions | |||
| delete duplicate entries in a large worksheet | Excel Discussion (Misc queries) | |||
| How do I get to the last line of a large spreadsheet to add data | Excel Worksheet Functions | |||
| Using SpecialCells().EntireRow.Delete on large worksheet - Very slow! | Excel Programming | |||
| Attaching a JET database to an Excel Worksheet OR storing large binary data in a worksheet | Excel Programming | |||
Threaded Mode
