#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 141
Default 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



  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default 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





  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 141
Default 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







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"