Any difference between Sheets Activate and Select?

D

Don Wiss

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

Don <donwiss at panix.com>.
 
C

Chip Pearson

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 [email protected]
 
Top