Thread: what's the difference between Activate and Select for Worksheet?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
lvcha.gouqizi lvcha.gouqizi is offline
external usenet poster
  
Posts: 38
Default what's the difference between Activate and Select for Worksheet?
Hi,

As I know that after

worksheets("****").Select, then we can use
ActiveSheet.**** to do anything.

But how about the Activate method? Can we use

Worksheets("****").Activate
ActiveSheet.****

in the way?

thanks.

Reply With QuoteReply With Quote