Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
select vs activate
Hi Simon
You can select a range for examples and activate one cell in that selection Range("A1:C10").Select Range("A5").Activate If it is one cell then you can use both -- Regards Ron de Bruin http://www.rondebruin.nl "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) | |||
select vs activate | Excel Programming | |||
Difference between .Activate and .Select | Excel Programming | |||
Any difference between Sheets Activate and Select? | Excel Programming |