Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referring to a hyperlink
I have a cell that has a hyperlink added to it via CTRL-K.
Is there a way for the hyperlink function to grab that info? As opposed to having a path stored in a cell, I have a "friendly name" in there with ctrl-k'd hyperlinks. I know how to use hyperlink if my target cell contains a path name in clear text, just not the other way. Hope I'm clear. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referring to a hyperlink
Take you hyperlink apart into two parts and then use the hyperlink() function:
First enter this tiny UDF: Function hyp2(r As Range) As String hyp2 = r.Hyperlinks(1).Address End Function This function will return the URL or target of the hyperlink. If your hyperlink is in A1 then in B1 put =A1 gets you the friendly name in C1 put =hyp2(A1) gets you the URL or target in D1 put =HYPERLINK(C1,B1) this gives you the hyperlink as a function. -- Gary's Student " wrote: I have a cell that has a hyperlink added to it via CTRL-K. Is there a way for the hyperlink function to grab that info? As opposed to having a path stored in a cell, I have a "friendly name" in there with ctrl-k'd hyperlinks. I know how to use hyperlink if my target cell contains a path name in clear text, just not the other way. Hope I'm clear. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referring to a hyperlink
Thanks. Much to learn I have...
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink won't open any other XLS file | Excel Discussion (Misc queries) | |||
How do I emulate rightclick on a hyperlink in an Excel Macro | Excel Discussion (Misc queries) | |||
Using the Hyperlink Function and finding filenames | Excel Worksheet Functions | |||
Importing Data from an Access Database Including a Hyperlink Colum | Excel Discussion (Misc queries) | |||
Removing hyperlink | Excel Discussion (Misc queries) |