Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Slow macros cont.....
Hi All
From my original example (see the bottom of the page) I have replaced Rows("600:600").Select Selection.Delete Shift:=xlUp with Rows("600:600").Delete Shift:=xlUp This has helped a considerable amount, however, it zooms through about 150 to 200 rows then slows again. Excel 2002 is a real pain at the moment. can any one advise me further Cheers Original Example Sub Delete_Row_600_551() Sheets("Data").Select If Range("G600") < Range("Q1") Then Rows("600:600").Select Selection.Delete Shift:=xlUp End If If Range("G600") Range("S1") Then Rows("600:600").Select Selection.Delete Shift:=xlUp End If If Range("G599") < Range("Q1") Then Rows("599:599").Select Selection.Delete Shift:=xlUp End If If Range("G599") Range("S1") Then Rows("599:599").Select Selection.Delete Shift:=xlUp End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - Slow & can't run macros | Excel Discussion (Misc queries) | |||
Macros Running Sometimes Slow Sometimes Fast | Excel Discussion (Misc queries) | |||
Excel 2002 - Slow macros | Excel Programming | |||
Excel Macros Slow in XP | Excel Programming | |||
Macros run slow in XP | Excel Programming |