Need help making this faster

Is it ok to ask for help?
I need to make this faster:

Please Login or Register  to view this content.

What is this code supposed to do? Perhaps if you posted a sample workbook showing some sample fake data (20-30 rows max, should suffice), then we can run this macro and observe it's effects.

Or post a workbook with BEFORE/AFTER examples already there....

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Without attempting to rewrite... eliminating human actions from the code should help. VBA normally has no need to "select" anything before acting on it.

So maybe change these two line:

Please Login or Register  to view this content.

...to simply:

Please Login or Register  to view this content.

There are two places in your code where that would help.


Also, above the DO you can turn off the screen to speed up execution,

Please Login or Register  to view this content.

and turn it back on below the loop:

Please Login or Register  to view this content.

Thanks for the feedback.

As it appears you've reached a conclusion, I've marked this thread SOLVED for you.
FYI, this is done through the Thread Tools located above the first post in this thread. Thanks.