View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
SP[_3_] SP[_3_] is offline
external usenet poster
 
Posts: 7
Default 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