View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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.