LinkBack URL
About LinkBacks
Running the macro for a thousand rows took about 12 minutes. Is there any way to improve the speed? Examples provided would be greatly appreciated.
part of the codes:
Please Login or Register to view this content.
Comparison Efficiency
Running the macro for a thousand rows took about 12 minutes. Is there any way to improve the speed? Examples provided would be greatly appreciated.
part of the codes:
Please Login or Register to view this content.
Last edited by jasmine417; 12-21-2011 at 10:02 PM.
Is the code you provided from a userform?
If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.
---Keep on Coding in the Free World---
It is from a module
Last edited by jasmine417; 12-21-2011 at 11:07 PM.
One obvious speed improvement would be to turn of screen updating:
(Remember to turn it back on again).Please Login or Register to view this content.
yes, I forgot to mention that I have already turned off all the unecessary settings. Anything besides that?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks