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.




"SP" wrote:

What's the difference between select and activate ?

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

Thanks
Steve

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" 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

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