Dim rngTemp As Range
Set rngTemp = Sheets("Sheet2").Range("A1")
Application.Goto Reference:=rngTemp

If this post helps click Yes
---------------
Jacob Skaria


"Nev" wrote:

I use the line below in part of my spreadsheets.

Application.Goto Reference:=Range("'addresses'" & "!a1")

Range("B7").Select

I would like to use this elsewhere where 'addresses' is a variable

ie It would pick up whatever is in sheet "info" F30 and take me to the
relevant sheet

How can I do this?

thanks

Nev