| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Difference between .Activate and .Select
Please clear up a bit of fog for me.
When I run: Sheet04.Activate Sheet05.Select both have the same effect; they make the sheet active. But I'm thinking that there must be, perhaps, a suttle difference between the two. Can anyone tell me what the suttle difference might be, and when it would be more approriate to use one over the other? Thanks TTFN JMMach |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Difference between 'Open', 'Select' and 'Expand' | Excel Discussion (Misc queries) | |||
| .Activate vs. .Select in VBA | Excel Discussion (Misc queries) | |||
| frustrated with VBA select/activate and screen flips | Excel Discussion (Misc queries) | |||
| Smart use of .Activate; .Select; .Copy with Sheets(1) va Worksheet | Excel Discussion (Misc queries) | |||
| Any difference between Sheets Activate and Select? | Excel Programming | |||
Threaded Mode
