Hi I am looking for some help on this in macro I have over 185000 rows and I ran this code it took over hour to run.
Do you a faster code that can accomplish the same as this one in less time?
Any help is greatly appreciated
Please Login or Register to view this content.
hi,
see if it helps you
Please Login or Register to view this content.
if you want to know how long it takes to be completed...
Please Login or Register to view this content.
Last edited by john55; 01-13-2012 at 03:47 AM.
Regards, John55
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
...enjoy -funny parrots-
beforehand thank for your help I try using the code that you posted and it run really fast but it is giving me different result than the one posted so I attach a sample spreadsheet so you can see why is erasing everything on d and the other 3 columns to the right
hi martinez,
try this one
Please Login or Register to view this content.
See if this works for you, it should be a tad faster than looping
Please Login or Register to view this content.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks