How do I keep a hyperlink valid if the link to cell is moved?
If I use a hyperlink from one cell to another in the same worksheet and then
the cell to which the link refers moves within the worksheet, the link is no longer linking to the correct cell. How do I prevent this/ Thank you. |
How do I keep a hyperlink valid if the link to cell is moved?
If you're using the insert|Hyperlink type of hyperlink, then I'd replace them
with the =hyperlink() worksheet function. You could either name the linked cell (insert|Name|define) and point to that named cell: =hyperlink("#TestName","Click Me") (The name is TestName. The # is the hyperlink subaddress character.) Or use a formula like one of these that David McRitchie posted: =HYPERLINK("#"&CELL("address",C5),C5) =HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5) =HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5) kendeboer01 wrote: If I use a hyperlink from one cell to another in the same worksheet and then the cell to which the link refers moves within the worksheet, the link is no longer linking to the correct cell. How do I prevent this/ Thank you. -- Dave Peterson |
All times are GMT +1. The time now is 03:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com