| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fast Way to Delete Rows from Big Spreadsheet (Using VBA)
Hi,
I had the same problem recenty. Macro deleting rows worked very slow. The problem was with page breaks. After each row delete, excel must calculate where are the page breaks. Just go to tools - options - view -page breaks - disable. I hope this helps Cheers Pawel |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to delete alternate rows in a spreadsheet? | New Users to Excel | |||
| Macro to delete certain rows in a spreadsheet | Excel Programming | |||
| Macro/VBA to delete rows in Spreadsheet | Excel Programming | |||
| How do I delete both duplicate rows from a spreadsheet? | Excel Discussion (Misc queries) | |||
| Need a fast way to delete rows | Excel Discussion (Misc queries) | |||
Threaded Mode
