Avoiding the use of ".select"

[dagindi]

In a recent thread, RoyUk wrote "The most important thing is to not select any sheets or ranges, doing so will slow your code."

When I use the Macro Recorder it always returns something with ".select", for example:

Please Login or Register  to view this content.

What is the best way to code this without ".select" so that my codes stay lean and mean.

[davegugg]

I think this is "lean and mean":

Please Login or Register  to view this content.

A lot of times with the macro recorder, you can take where one line ends with .Select and the next line begins with Selection. and just join them by deleting the Select/Selection verbiage and space in between.

[contaminated]

Yo've got many false staements in the 1st With EndWith code. So u can erase them, I'm sure this wont affect on your code. Same as For borders..So shortened version posted below. please try this out and let me know if it works same as first-posted code.

Please Login or Register  to view this content.

[davegugg]

Hi contaminated. Just wanted to point out that if the OP is trying to clear off existing borders, your code will not work.

[dagindi]

Dave,

The macro you provided works perfectly.

I will also be using "you can take where one line ends with .Select and the next line begins with Selection. and just join them by deleting the Select/Selection verbiage and space in between." as my rule of thumb to eliminate the .select/selection and hopefully speed up my macros.

Thanks!!

[dagindi]

Contaminated,

Thanks for the code. This particular report has borders and shading that I want to remove.

In the end I took Dave's code and your recommendation to erase the false statements and its running smoothly.

I don't know if I see a difference in the overall speed between having .select, but I am sure as these reports grow it will be beneficial.

Thanks and I'll be adding to both of your reps...

Cheers!!