Solved: Select vs. Activate

[compariniaa]

I know that selecting objects in VBA slows things down a lot and is pretty unneccessary. But what about activating them?

[matthewspatrick]

Yes, this is typically unnecessary and yet slows down your execution.

[compariniaa]

I'm a little confused....are you confirming what I said about selecting, or are you saying that activating is unnecessary and slow?

[matthewspatrick]

Sorry :) Activating is slow, and almost always unnecessary.

[compariniaa]

ah..got it. thanks matt