ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   select vs activate (https://www.excelbanter.com/excel-programming/309470-re-select-vs-activate.html)

Ron de Bruin

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.





All times are GMT +1. The time now is 06:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com