Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Dora Medina   on Oct 29 In MS Office Category.

Select OR Activate a Sheet (?)


  
Question Answered By: Seth Anderson   on Oct 29

Here the REAL difference between these two statements
Sheets("Sheet1").Select and Sheets("Sheet1).Activate

Lets say, you would have "Sheet2" as a hidden sheet,
and have "Sheet1" as a non-hidden(visible) sheet.

The REAL difference is this:
For "Sheet2", you can do Sheets("Sheet2").Activate
but cannot do Sheets("Sheet2").Select
because "Sheet2" is hidden.

For "Sheet1", you can do Sheets("Sheet1").Activate
and also do Sheets("Sheet1").Select
because "Sheet1" is non-hidden(visible) sheet.

Share: 

 

This Question has 8 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Select OR Activate a Sheet (?) Or get search suggestion and latest updates.


Tagged: