Dim S as String
S = Range("C3").Value
Application.Goto Range(S)
--
Gary's Student


" wrote:

Hi all,

I'm sure this is any easy one,

How do you make a got to range/reference dynamic?

You see I want to goto to use the range stated in a cell

Ie

Application.Goto Range("c3")

But this code only goes to the cell not the range in the cell??

Thanks