Macro to "go to" specific cell in a different sheet

[baheck9200]

I have a seriew of drop-down combon boxes that ultimately "drill-down" to a resulting sheet & cell reference in cell F7. Based on the criteria selected in these drop-downs the resulting sheet & cell reference (cell F7) will change. I am looking for help with a macro that, when run, will take me to the sheet & cell referenced in cell F7. When I do a goto function it always remember the last place I went to and never goes to the latest data in cell F7.

Brent

 

[VoG]

The 's are the problem. Try

Sub gto()
Dim x
x = Split(Range("F7").Value, "!")
x(0) = Replace(x(0), "'", "")
Application.Goto reference:=Sheets(x(0)).Range(x(1))
End Sub

 

[baheck9200]

I got it to work finally. I actually did it without a macro. I used the following formula:

=HYPERLINK(CONCATENATE(MID(E6,32,40),TEXT(F10,"text")))

Of course, there are 4 or 5 other formulas that lead up to this hyperlink formula, but it works and that is what matters.

Thanks for your help.

 

[erik.van.geit]

I got it to work finally. I actually did it without a macro. ..., but it works and that is what matters.

FINE! what matters too is that you indicate whether you want VBA or not: you asked for VBA and were probably not aware that it could be done without VBA, but if you would have told that in your initial post, you would have gotten the HYPERLINK answer straight away

have a nice time,
Erik

 

[baheck9200]

Lesson learned. Thanks.

I actually stumbled on the hyperlink answer by accident.

 

[Silverjman]

Thanks Erik!