Hi. I have the following code but it runs rather slow as there is about 1500 rows. Any idea how to speed it up? Macro looks at sheet F and sheet CG and if a certain few cells exists already in sheet CG that is in sheet F, then this deletes the row from sheet F
Please Login or Register to view this content.
Last edited by ScabbyDog; 03-25-2013 at 11:52 AM.
a loop within a loop will normally be relatively slow and deleting one row at a time will also be slow. the delete can be improved using
if that is still too slow it ought to be possible to improve the searching tooPlease Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
Yeah it's still too slow
Actually the above speeds it up! It's this code that seems to be slowing it down.
Please Login or Register to view this content.
Can the above code be quickened up?
exact same principle
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks