Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a sub routine that runs though a series of workbooks, and through
each worksheet within each workbook. The routine performs it's purpose and determines whether a row needs to be deleted. If a condition is met then the flowing line of code performs the deletion: [ForecastStart].Offset(r - 1, 0).EntireRow.Delete xlShiftUp When the code runs the various workbooks are opening, the worksheets looped through and saved and closed again. PROBLEM The code starts of running very quickly but slowly slows to a crawl. The line of code above is the one which causes the problem. When I step through the code it is this line that takes longer and longer to execute as the length of time the program has been running lengthens. The order I loop through the workbooks makes no difference. If I loop in a different order the workbooks, with the apparently slow workbooks at the front then they whizz through and the fast ones now crawl. Both screenupdating has been set to false and calculation set to manual to try to alleviate the problem. Please please someone give me some things to try! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Borders slowing filter process in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2007 chats slow to a crawl | Charts and Charting in Excel | |||
excel 2003 slowing down | Excel Discussion (Misc queries) | |||
Excel slowing down during usage | Excel Discussion (Misc queries) | |||
Why Excel is accessing Internet & Slowing Excel Performance | Excel Discussion (Misc queries) |