Get Hyperlink Address

imported_Anonymous · Feb 10th 2003

I have a cell with text, and it's hyperlinked

for example the cell A1 has text "MY LINK" and it is linked to "http://mylink.com/"

I want the cell next to it (A2) to show the url

If I use "=A1" it only shows the text, not the url. And if I use =Hyperlink:A1 or something similar it has the text and the link, but i ONLY want the link

Is there a command like "=A1("url")" or something like that to show the url of the text in that cell?

can someone please reply asap and email me the little piece of code at [email protected]

thanks in advance

Dave Hawley · Feb 10th 2003

Hi

You can use this UDF that I have

Code

Function GetAddress(HyperlinkCell As Range)
    GetAddress = Replace _
    (HyperlinkCell.Hyperlinks(1).Address, "mailto:", "")
End Function

If unsure on how to use it in your Worksheet see HERE

imported_Anonymous · Feb 10th 2003

Thank you really really much

Also thanks for the quick reply

Appreciate it

It works great

Get Hyperlink Address

Participate now!

Share