VBA for "GoTo" variable cell reference

[cvincent]

I have a spreadsheet that adds columns daily. I have a cell that finds the maximum value in the row, and also identifies the cell reference.

I want my macro to copy that cell reference into the "goto" box, but I can't make the cell reference variable.

How can I make it vary?
This is the part of the macro that isn't working:

Application.Goto Reference:="R54C4" (cell that contains the address)
Selection.Copy
Application.Goto Reference:="R7C601" (this needs to be variable - tried pasting the copied cell address into the "goto" box, but if will only go to this address)

 

[Jonmo1]

This works for me.

Dim MyVariable As String
MyVariable = Range("D54").Value
Application.Goto Reference:=Range(MyVariable)

 

[cvincent]

Worked like a charm. Thank you, jonmo1!

 

[Jonmo1]

Glad to help, thanks for the feedback.