Any difference between Sheets Activate and Select?
 

Is there any difference between Sheets("Sheet1").Activate and Sheets
("Sheet1").Select?

Don <donwiss at panix.com.

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.