I have the macro below which works as intended... except... it takes 15-20 minutes to go through 2000 lines.
Any suggestions on how to speed it up, perhaps by writing the macro differently? Any help is appreciated!
Please Login or Register to view this content.
Hi
When deleting rows, it is better to start at the bottom and work up.
ryloPlease Login or Register to view this content.
Try this one:
Please Login or Register to view this content.
Ben Van Johnson
Hi DKabi,
Your's is running off the end because rownum never gets to 2000!
This is called "block deletions":
Please Login or Register to view this content.
Last edited by xladept; 04-16-2013 at 07:48 PM.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Thanks everyone for your suggestions. I decided to go with Rylo's code, as it appeared to be quickest to execute.
Hi DkAbi,
I believe that Ben's code is by far the quickest
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks