LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 25
Default Macro slow down

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
slow macro :)[_2_] Excel Discussion (Misc queries) 1 March 3rd 10 02:41 PM
Macro - very slow run in 2003 murkaboris Excel Discussion (Misc queries) 3 September 28th 09 09:28 PM
Macro is very slow jlclyde Excel Discussion (Misc queries) 2 September 29th 08 04:43 PM
Macro it's very Slow .... leo_nunez[_2_] Excel Programming 4 August 28th 04 03:45 PM
Does OnTime slow macro down? Jeff Armstrong Excel Programming 0 August 2nd 04 08:13 PM


All times are GMT +1. The time now is 06:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"