Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Slow In Execution Under Excel 2002
I have a macro which checks and deletes certain line of data depending on the
details they hold. At times, it could be deleting a few hundred lines. When run under Excel 2000 or 2003, it completes in about 20 seconds. However, it's almost "hanging" when run under Excel 2002. This was zeroed in to a simple EntireRow.Delete command. It takes about 20 to 30 seconds to delete each line. Different PCs and OSes were used with the same result. Anyone knows if there's a bug in Excel 2002? and any solution to fix it? Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel to Powerpoint Slow Execution | Excel Programming | |||
Extremely Slow VBA Execution Speed | Excel Programming | |||
Macro speed - SLOW in 2002, FAST in '97?? | Excel Programming | |||
slow macro execution | Excel Programming |