VBA-DIFFERENCE BETWEEN SHEETS.SELECT AND SHEETS.ACTIVATE

SHEETS.SELECT or SHEETS.ACTIVATE


What is the exact difference between Sheet.Activate and Sheet.Select. We have always managed to get the required thing done but still many of us are not sure of the exact difference. So this is how it goes.
Consider the following set of statements:
1.       Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Select

Sheets("Sheet2").Activate





2.       Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Select

Sheets("Sheet2").Select


What would be the difference in the result of the two statements?
The first statement would activate Sheet2 (all other sheets are still selected). However the second statement, i.e. if you use select, Sheet2 is the only sheet that is selected.
So..
With Activate, if you presently have more than one sheet selected, the ActiveSheet will change, but all selected sheets will remain selected.
Select can select multiple objects. Activate can activate only one object. To select a cell or a range of cells, use the Select method. To make a single cell the active cell, use the Activate method.

  1. gravatar

    # by Anonymous - April 6, 2010 at 7:22 PM

    nice answer, that is exactly wht i was looking for.
    Thanks.

  2. gravatar

    # by Daniel - July 23, 2010 at 9:55 PM

    I am on the same opinion!!!

  3. gravatar

    # by Ryan - October 29, 2010 at 12:15 AM

    Yes, many thanks! Great description--concise and informative.

  4. gravatar

    # by Tyrone - December 1, 2010 at 4:21 PM

    Excellent answer!

    All of the other threads which I have read tell me to "se neither", but do not answer the question!

    Thank you for such a concise yet descriptive example.

  5. gravatar

    # by Anonymous - February 25, 2011 at 9:26 AM

    impressive!

  6. gravatar

    # by Anonymous - June 4, 2012 at 5:13 PM

    That explanation nails it!
    Thx

  7. gravatar

    # by Anonymous - July 11, 2012 at 12:45 AM

    Excellent Answer! Whenever this question is posed on other websites, people never actually answer the question.

    They always give smart-assed responses such as "You don't need either method..." or "I'm so smart. Watch me spew off my paid for Education."

    Thank you so much, Good Sir, for being the only person to actually answer the question, and for not being condescending or pedantic.

  8. gravatar

    # by Analyst - July 31, 2012 at 5:17 PM

    Appreciate your encouragement!

Blog Widget by LinkWithin

Search this blog..

Loading