variable in application line

  • Thread starter Thread starter Nev
  • Start date Start date
N

Nev

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
 
Dim rngTemp As Range
Set rngTemp = Sheets("Sheet2").Range("A1")
Application.Goto Reference:=rngTemp

If this post helps click Yes
 
Jacob

Thanks for the quick reply. Sorry - I want to use whatever is in "Info F30"
as the variable. Therefore if "Info F30" said May it would take me to
worksheet "May", Sept to worksheet "September" etc

Thanks

nev
 
Dim strSheet as String
strSheet = Sheets("info").Range("F30")
Sheets(strSheet).Activate

OR

Dim strSheet as String
strSheet = Sheets("info").Range("F30")
Application.Goto Reference:=Sheets(strSheet).Range("A1")
 
Back
Top