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 (e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
select case syntax to other sheets 5
Selection on a non-active sheet? 2
Activate .. Select .. Initialize 5
ActiveCell on inactive sheet 8
Run Macro on All Sheets Q 8
range name define on non active(focused) sheet 10
Create new sheet based on cell value 1

Top