Activate vs Select
One thing VBA programmers often grapple with is whether or not to use
.Select when working with objects like worksheets and cells. So what is the difference, and when would you use one method over another? To put it simply,
.Activate sets focus to a single object, while
.Select allows for multiple items to be selected. As an example, you can select multiple cells on a worksheet, but only one of those cells can be active at any given time.
Having explained this, there is another important issue surrounding these two functions, and that is, whether they should be used at all… My experience has taught me that they are rarely ever required, if at all.
To find out why, please read my post on Performance Tuning in Excel: Activate vs Cell Referance