goto function in macro

[mohavv]

Hi,

I got stuck creating a macro which would let me go to the linked cell
from the current selection.

I have a workbook with several links. For checking purposes I want to
create a macro which would take me to the cell to which the current
cell is linked to.

My problem is I don't know how to use the the text from the formula in
the current cell in stead of the value.

Cheers,

Harold

PS is there also a way that would bring me back to my starting point.

 

[David McRitchie]

Hi,

I got stuck creating a macro which would let me go to the linked cell
from the current selection.

I have a workbook with several links. For checking purposes I want to
create a macro which would take me to the cell to which the current
cell is linked to.

My problem is I don't know how to use the the text from the formula in
the current cell in stead of the value.

Cheers,

Harold

PS is there also a way that would bring me back to my starting point.

Hi Harold, (these first items are not macro solutions)
Not sure of the question does this work for you.
Hyperlink Worksheet References outside of quotes (#hyperlink_ref)
Worksheets in VBA Coding and in Worksheet Formulas
http://www.mvps.org/dmcritchie/excel/sheets.htm#hyperlink_ref

The back to the starting point is easy. Use the BACK button
same as used in Internet Explorer or other browsers, or that you might
be using on a five button mouse. (alt+arrowleft) You can put the
arrows on your pre Excel 2007 with customize. As long as you
got there with a LINK.

also see on same page, this does use VBA code
Link Back to Sheet (#followhyperlink)