Dynamic Range in VBA
 

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

Dynamic Range in VBA
 

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

Dynamic Range in VBA
 

Perfect,

Thanks a lot for that.

I really needed it

Thanks
again

Dynamic Range in VBA
 

You are very welcome !
--
Gary's Student


" wrote:

Perfect,

Thanks a lot for that.

I really needed it

Thanks
again