Selecting vs Activating - VERY newbie

Sam05

New Member
Joined
Feb 7, 2009
Messages
23
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

MrExcel MVP
Joined
Aug 21, 2004
Messages
16,995
Activate can only activate only one object.

Select can select multiple objects.

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

Sam05

New Member
Joined
Feb 7, 2009
Messages
23
Hi jindon,

thanks. Same applies to the following?

Code:
Sheets("Sheet1").Select
and

Code:
Sheets("Sheet1").Activate
or is this syntax used for different purposes?
 

jindon

MrExcel MVP
Joined
Aug 21, 2004
Messages
16,995
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.
 

Forum statistics

Threads
1,081,415
Messages
5,358,533
Members
400,502
Latest member
price83

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top