Difference Between Select and Activate Methods in VBA

Bottom line: Learn the difference between these two commonly used methods in VBA.

Skill level: Intermediate

Select vs. Activate

One question I hear often from new members of our VBA Pro Course is, “What's the difference between Select and Activate? It seems like they do the same thing?”

Select vs Activate in VBA for Excel

The short answer is that Select and Activate can perform the same action, but the differences are:

  • Select can be used to select multiple objects (sheets, ranges, shapes, etc.) at the same time.
  • Activate can be used to active one object within the selection.

Let's take a look at an example to see how this works.

Which Method Should I Use?

First, it's important to note that both methods can be used on many different types of objects in Excel. This includes sheets, ranges, cells, shapes, charts, slicers, etc. We'll use worksheets in this example.

The use case for each method depends on the scenario. And as I explain below, it's usually best to use neither. 😲

When to use the Select Method

The Select method is typically the one we're most familiar with because the macro recorder uses it when generating code.

Select allows us to select a single object OR multiple objects.

The following line of VBA code selects a single worksheet.


We can also use Select to select multiple objects. Here is an example of selecting multiple ranges.


Here is an example of selecting multiple sheets. The Array function is used to reference the sheets. This same technique can be used for shapes.

  Worksheets(Array("Sheet2", "Sheet3", "Sheet5")).Select

When that line of code is run, the first item in the array is activated. That means that Sheet2 will be the active sheet that the user sees.

VBA Select Method First Object in Array is Active

What if we want to keep the three sheets selected, but have the user view Sheet3 instead? This is where the Activate method comes into play.

When to use the Activate Method

The Activate method allows us to select a single object. This can be a single object within a selection, if multiple objects are already selected.

The following lines would select the three sheets, then make Sheet3 the active sheet that the user sees.

Worksheets(Array("Sheet2", "Sheet3", "Sheet5")).Select

VBA Active vs Select Methods Multiple Sheets Selected

If you do not have a group of objects selected, then Activate will just select a single object. It does NOT add to the current selection and will work the same way that Select works.

Be Careful with Activate

You might not always know which objects are selected in the workbook. Therefore, you can't always use Activate to select a single object.

For example, let's say you have a line of code in your macro to activate Sheet1.

If the user has Sheet1 to Sheet3 selected before the macro is runs, then all three sheets will remain selected. You might not want this if your next line of code modifies a cell on Sheet1. Depending on how the code is written, all three sheets could be modified, causing unwanted results. 😬

If you activate an object that is NOT in the selection, then that single object will be selected and the previously selected objects will no longer be selected. For example, if the user has Sheet1 to Sheet3 selected and your code activates Sheet4, then only Sheet4 will be selected.

The main takeaway here is that there are a lot of potential unwanted outcomes when using Activate to select a single object. So, it's best to use Select for selecting single objects.

Activate for Workbooks

The Activate method is also used when activating Workbooks and Windows. There is no Select method for these objects.




Avoid Select and Activate Whenever Possible

It's great to know the difference between these two methods, but you might not need them as often as you think. Especially if you are just starting out with VBA and using the macro recorder a lot.

The macro recorder code contains a lot of lines with the Select method because it is generating code for every action we take. However, we do NOT need to select an object before we take actions on it. This can slow down our code and make it more prone to errors.

The Select Method is Like Using a TV without a Remote Control

Here is an article on How to Avoid the Select Method in VBA & Why that explains more.


It's best to use Select when you want to select a single object or multiple objects. Activate should be used when you want to activate (view/select) an object within an existing selection. Activate is also used to select Workbooks, as there is not Select method for that object.

Did I miss anything? Please leave a comment below with questions or suggestions. Thank you! 🙂


Your email address will not be published. Required fields are marked *

  • I would probably never search for an answer to this question, but you covered a topic that was one of those “why are there two methods that seemingly do the same thing?” kind of questions. Great explanation in that it was somewhat confusing before, but now I have a much better understanding of it.

    Thanks also for the emphasis of not having to select an object before doing something with it. It does help with debugging so see what is actually happening, but once it works we can probably take out some or all of the Select statements.

    • Thanks Patrick! And great point about selecting objects during debugging. This is especially true for sheets and workbooks, when you might want to see what the code is doing as you step through it with the F8 key.

      Thanks again and have a nice weekend! 🙂

  • Hi Jon,

    I’ve known about the inefficiencies of using Select for a long time, but I have to admit that I hadn’t really given much thought to Activate.

    Thanks for the clarification.

  • Difference between select is that you can select several objects at once. Objects that are selected are also placed in the Selection object which you can use methods on. Unless you are selecting multiple objects, selecting (say, a cell) activates the object.

  • Found that I can use ‘Activate’ to run desired changes on a hidden sheet (without unhiding it), while the same code with ‘Select’ errors out (unless I unhide the sheet first). Thought that was interesting to mention. Not sure if there are other things in play, but for my purposes, had to use ‘Activate’ vs. Select.

    • Fascinating to learn! But even then, it’s generally better to avoid using Activate at all, and instead assign a range (or use an explicit “hard-coded” range).

  • Office 365 in sheet1 I use sheets(“sheet2”).select because I want to get the value of selection.row in sheet2 to perform certain actions. However when at end sub sheet2 is displayed when I want sheet1 displayed.
    I tried sheets(“sheet1”).select and .activate both of which fail permanently and I can’t get back to sheet 1 until I’m out of vba and I have to reselect sheet1.

  • Thank you! That was quite helpful! Clear and concise explanation that I as a newbie could fully comprehend.

  • Your breakdown of VBA subtleties is superb! There is not a lot of fluff, you get right to it, define the challenge/problem and pursue a nice logical progression to solve. I really appreciate it.

  • “And as I explain below, it’s usually best to use neither. ”
    Thank you so much. You helped me take a macro that would have taken weeks to run down to about 12 hours.

Generic filters
Exact matches only

Excel Shortcuts List

keyboard shortcuts list banner

Learn over 270 Excel keyboard & mouse shortcuts for Windows & Mac.

Excel Shortcuts List

Join Our Weekly Newsletter

The Excel Pro Tips Newsletter is packed with tips & techniques to help you master Excel.

Join Our Free Newsletter