Can a hyperlink in a workbook reference a Range name such that it continues to link the original cell if the location changes (resulting, say, from someone inserting a row)? The hyperlink dialog box will not let me enter a range name only a cell so if that cell moves the link now references the wrong cell.
You were asked to update your thread title, not start a new thread. I will close the thread with the poor title.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Thank you . I couldn't figure out how to change the title.
Creates a hyperlink to the range named DeptTotal on the First Quarter worksheet in the workbook saved at http://example.microsoft.com/report. The cell on the worksheet that contains the hyperlink displays "Click to see First Quarter Department Total" as its jump text.
https://support.microsoft.com/en-us/...7-7de9b76f577f
Please Login or Register to view this content.
There were detailed instructions in the thread telling you how to do it.Originally Posted by aresquare1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks