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