Select a cell based on a named range that contains a cell reference

[jerry12302]

I have a range named GoToLink in Sheet2 that contains a cell reference, currently "Annual Revenues"!C5

I want the macro to go to the referenced sheet, "Annual Revenues", and select the cell C5.

I have tried many examples that I have found on the web, here and elsewhere, that do not work, even though the person asking replied that it worked. I'm using Windows 7 and Office 2010.

I've tried to simplify it by using code I found that just selects the sheet based on another cell. In Sheet2 C6 contains the sheet name, "Annual Revenues" (including the quotes).

Sub SelectCell
ThisWorkbook.Sheets(Worksheets("Sheet2").Range("C6").Value).Activate
End Sub

I get the error "Subscript out of range".

If I were to hard code the sheet and cell reference it would look like this, which works of course...

Sub SelectCell
Sheets("Annual Revenues").Select
Range("C5").Select
End Sub

How do I substitute the sheet name and cell reference using my range GoToLink which contains "Annual Revenues"!C5 ?

 

[Fluff]

Change the cell value to
''Annual Revenues'!C5
NOTE it needs to be two ' at the start & not a "
Then you can use this

Application.Goto Range(Sheets("Sheet2").Range("Gotolink")), True

 

[jerry12302]

Wow, that was one of the variations of code I found and tried before. I was going nuts trying to figure out why something so simple wouldn't work.

All because of a '.

Thank you Fluff, this works perfectly now.

 

[Fluff]

You're welcome & thanks for the feedback.