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.

what's the difference between Activate and Select for Worksheet?
 

You can activate a worksheet. If you look up Activate in VBA help, you will
get a full explanation.

--

HTH

RP
(remove nothere from the email address if mailing direct)


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