Selecting vs Activating - VERY newbie

[Sam05]

Hi all,

could someone please explain the differences between Selecting a sheet/wb and Activating a sheet/wb? when do you use each one, etc.?

Thanks

 

[jindon]

Activate can only activate only one object.

Select can select multiple objects.

With Range("a1:b10")
    .Select
    .Cells(2).Activate
    MsgBox Selection.Address & " is selected" & vbLf & _
               ActiveCell.Address & " is active"
End With

 

[Sam05]

Hi jindon,

thanks. Same applies to the following?

Sheets("Sheet1").Select

and

Sheets("Sheet1").Activate

or is this syntax used for different purposes?

 

[jindon]

Select for Sheet object has an argument (Replace)

Sheets("sheet1").Select replace:=False

will select Sheet1 & the sheet(s) already selected...

Sheets("sheet1").Activate will always Activate "Sheet1"

That's the only difference AFIK, so my answer to your question is no difference.

 

[Sam05]

Thanks Jindon, useful information for me.