| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Any difference between Sheets Activate and Select?
Is there any difference between Sheets("Sheet1").Activate and Sheets
("Sheet1").Select? Don <donwiss at panix.com. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Any difference between Sheets Activate and Select?
Don,
Using Select will ensure that only one sheet is selected. With Activate, if you presently have more than one sheet selected, the ActiveSheet will change, but all selected sheets will remain selected. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Don Wiss" wrote in message ... Is there any difference between Sheets("Sheet1").Activate and Sheets ("Sheet1").Select? Don <donwiss at panix.com. |
| Reply |
| 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) | |||
| Activate all sheets | New Users to Excel | |||
| Smart use of .Activate; .Select; .Copy with Sheets(1) va Worksheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
