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

L

lvcha.gouqizi

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.
 
B

Bob Phillips

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Active worksheet problem 3
Subscript out of range when selecting worksheet... 5
Offset in for loop not working 4
shorten sheet name 4
Activate .. Select .. Initialize 5
Userform causing a slip for Worksheet activate? 4
For Loop with headers 3
Where is My Data 1

Top