ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How To Q (https://www.excelbanter.com/excel-programming/345203-how-q.html)

John

How To Q
 
I know this has been answered before but I just can't find it..

I'm looking to have a particular cell at top left side but activate another
cell. Say M10 in top left corner, but cursor in P 16

Thanks




Ron de Bruin

How To Q
 
Hi John

You can do this

Application.Goto Range("M10"), True
Range("P16").Activate


--
Regards Ron de Bruin
http://www.rondebruin.nl


"John" wrote in message ...
I know this has been answered before but I just can't find it..

I'm looking to have a particular cell at top left side but activate another cell. Say M10 in top left corner, but cursor in P 16

Thanks






John

How To Q
 
Thanks Ron, thats the one. I'll remember to save it this time


"Ron de Bruin" wrote in message
...
Hi John

You can do this

Application.Goto Range("M10"), True
Range("P16").Activate


--
Regards Ron de Bruin
http://www.rondebruin.nl


"John" wrote in message
...
I know this has been answered before but I just can't find it..

I'm looking to have a particular cell at top left side but activate
another cell. Say M10 in top left corner, but cursor in P 16

Thanks









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

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