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.

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" <lvcha.gouqizi@gmail.com> wrote in message
news:1130517934.884216.171120@g14g2000cwa.googlegroups.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.
>