select vs. activate
 

What's the difference between select and activate ?

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

Thanks
Steve

select vs. activate
 

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




"SP" wrote:

What's the difference between select and activate ?

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

Thanks
Steve

select vs. activate
 

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

select vs. activate
 

thank you

"JMB" wrote in message
...
Generally, many folks use them interchangeably. the difference is you can
select several sheets, but only one is the activesheet. same thing for
ranges.




"SP" wrote:

What's the difference between select and activate ?

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

Thanks
Steve

select vs. activate
 

thank you

"OJ" wrote in message
oups.com...
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