I am creating a hyperlink to jump to cell A26 but when a cell is inserted above it doesnt follow the cell and go to A27. So if i added 10 rows the text would be at A36 but when the hyperlink is selected it will go to A26 which could be the wrong inforamtion!
Is there a way to lock it to that text?
Last edited by snoopy1461; 12-14-2011 at 10:58 AM. Reason: solved
=HYPERLINK("#A26") will always link to A26
Entia non sunt multiplicanda sine necessitate
I am looking for something that doesnt always link to cell A26, but if i add a row above the it then links to cell A27? Does that make sence?
Ah:
=HYPERLINK("#" & CELL("address", A26)) (volatile)
=HYPERLINK("#" & ADDRESS(ROW(A26), COLUMN(A26))) (non-volatile)
Thanks for this!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks