how do I create a macro to "Go To" a location specified in a cell?

[Guest]

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?

 

[Ron de Bruin]

Hi Kim

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

 

[Guest]

you are a super star!!!! thank you so much )

Hi Kim

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