| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Smart use of .Activate; .Select; .Copy with Sheets(1) va Worksheet | Excel Discussion (Misc queries) | |||
| Difference between Select and Activate | Excel Programming | |||
| select vs activate | Excel Programming | |||
| Difference between .Activate and .Select | Excel Programming | |||
| Any difference between Sheets Activate and Select? | Excel Programming | |||
Linear Mode
