Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Update a hyperlink in excel spreadsheet
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Sheeloo, post: 3821162"] Since A5 has 35400, Define BOTTOM as 'refers to; A1 Enter this in A1 ="A" & $A$5 so that you get A35400. Insert Hyperlink referring to BOTTOM Now redefine BOTTOM as 'refers to; =INDIRECT(A1) [For a reason I do not understand, BOTTOM does not show up in Hyperlink dialog if it has INIRECT formula... Hyperlink works if you change the formula for BOTTOM later] with A1 as [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Update a hyperlink in excel spreadsheet
Top
