Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
select vs activate
While a Selection of cells may contain any number of cells, only
a single cell may be active. Select selects a range of cells, and Activate make one of those cells Active. For single cell ranges, Select and Activate do the same thing. For multi-cell ranges, Activate makes one of the selected cells Active. For example, run the following code: Sub AAA() Range("A1:A10").Select Range("A5").Activate End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Simon Shaw" wrote in message ... what is the difference between using .Select and .Activate? i.e. why would I use one vs the other? When I use .Select I find I get more errors, but its not consistent. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
.Activate vs. .Select in VBA | Excel Discussion (Misc queries) | |||
frustrated with VBA select/activate and screen flips | Excel Discussion (Misc queries) | |||
Smart use of .Activate; .Select; .Copy with Sheets(1) va Worksheet | Excel Discussion (Misc queries) | |||
Difference between .Activate and .Select | Excel Programming | |||
Any difference between Sheets Activate and Select? | Excel Programming |