View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Select OR Activate ? Which when and Why?

Usually not necessary or desirable

range("a2:a33").copy range("b3")

--
Don Guillett
SalesAid Software

"Buffyslay" wrote in message
ups.com...
Select OR Activate ? Which when and Why?

i have never been able to work out when i should select and when i
should activate when using vba - does anyone have a good explanation?