Get URL from a Hyperlink

July 9, 2010 by admin

Now use the =GETURL(cell) to get the URL

Example: =GETURL(A1) will return the URL for the Hyperlink displayed in cell A1

Function GETURL(HyperlinkCell As Range)

GETURL = HyperlinkCell.Hyperlinks(1).Address

End Function