Thread: how do I create a macro to "Go To" a location specified in a cell?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
kim.in.denver kim.in.denver is offline
external usenet poster
  
Posts: 2
Default how do I create a macro to "Go To" a location specified in a c
you are a super star!!!! thank you so much :o)
"Ron de Bruin" wrote:

Hi Kim

Try this
Range(Range("A1").Value).Select


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


"kim.in.denver" wrote in message
...
Based on user input, I have used formulas to create a variable location in
cell A1. I need a macro that will "Go To" that location. Since the row and
column are variable I can't use a Range Name.

Any ideas?



Reply With QuoteReply With Quote