Hyperlink to cell within a sheet breaks when cells are sorted

C

CJ55

How can I lock down (or make relative) a hyperlink? I'm adding hyperlinks
between Sheet 1 (Schedule) & Sheet 2 (2009 Projects); when I sort Sheet 2,
the hyperlink on Sheet 1 is no longer valid. For example, the text originally
contained in my hyperlink to '2009 Projects'!$A7 has now moved to A10 as a
result of being sorted.

How can I make the hyperlink stay in sync with the correct text/cell? I've
tried pasting as link, tried placing the $ in various places, to no avail.

Appreciate any suggestions!
 
J

Jacob Skaria

=HYPERLINK("#"&CELL("address",'2009 Projects'!A7),"Click me")

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I make a Hyperlink to a cell within another worksheet rela 5
How to determine within a macro if a cell contains a hyperlink. 4
Use a hyperlink to display a selection of cells on another sheet (in same workbook) 1
Hyperlink to cell within the same Workbook 3
How to really protect cell formatting in a protected sheet 2
HELP W/ VBA: SELECT RANGE, ALLCAPS, CELL COLOR, RETURN TO BLANK CELL/PATTERN CELL 5
How to find a specific inform with some cells and return total 0

Top