Goto a referenced cell
 

Is there a way to go to a cell address written in another cell.
Example: In cell E13 I have the text "H12". I want the macro to look at
cell E13, read the value H12 and goto cell H12. Thanks for your help in
advance.

Michael

Goto a referenced cell
 

Hi

Try this

Dim var As String
var = Range("E13").Value
Application.Goto Range(var)


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


"mburkett" wrote in message oups.com...
Is there a way to go to a cell address written in another cell.
Example: In cell E13 I have the text "H12". I want the macro to look at
cell E13, read the value H12 and goto cell H12. Thanks for your help in
advance.

Michael