D Don Wiss Oct 28, 2003 #1 Is there any difference between Sheets("Sheet1").Activate and Sheets ("Sheet1").Select? Don <donwiss at panix.com>.
Is there any difference between Sheets("Sheet1").Activate and Sheets ("Sheet1").Select? Don <donwiss at panix.com>.
C Chip Pearson Oct 28, 2003 #2 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)
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)
