select vs. activate

  • Thread starter Thread starter SP
  • Start date Start date
S

SP

What's the difference between select and activate ?

Ex. sheets("abc").select and sheets("abc").activate

Thanks
Steve
 
Generally, many folks use them interchangeably. the difference is you can
select several sheets, but only one is the activesheet. same thing for
ranges.
 
try this...

Sub selectem()
ThisWorkbook.Sheets(Array(1, 2, 3)).Select
End Sub

Then try this...

Sub selectem()
ThisWorkbook.Sheets(Array(1, 2, 3)).Activate
End Sub

One difference....;o)

OJ
 
thank you

JMB said:
Generally, many folks use them interchangeably. the difference is you can
select several sheets, but only one is the activesheet. same thing for
ranges.
Click to expand...
 
Back
Top