Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a macro which checks and merges and deletes certain lines of data
depending on the details they hold. As this macro progresses, it starts to slow down. I have tried several things including... Application.cut.copymode = false .... but nothing works. I have pinned it down to one line in the code, a simple entirerow.delete command which can take up to 20 seconds to execute. Does anyone know why this is happening, and how it can be rectified? It really gets bad with about 600 lines left to delete, and i can't wait around for 1/2 an hour to do the last little bit! Thanks in advance for all your (anticipated) help... Jonny |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
slow macro | Excel Discussion (Misc queries) | |||
Macro - very slow run in 2003 | Excel Discussion (Misc queries) | |||
Macro is very slow | Excel Discussion (Misc queries) | |||
Macro it's very Slow .... | Excel Programming | |||
Does OnTime slow macro down? | Excel Programming |