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

Activate .. Select .. Initialize 5
Activate vs Select a sheet 4
Clearing a chart title with less lines of code 1
select case syntax to other sheets 5
Help with activating window from Application.GetOpenFilename 4
= Today()+1 into Sheet1, Sheet2, and Sheet3 2
Code not working as expected 2
Help with code please 4

Top