Get the URL from an Excel Hyperlink « Contextures Blog

There's a minor bug with HLink() in that if the link contains a # then it only returns the part before the # sign. To get the full URL it should be coded as: Function HLink(rng As Range) As String 'extract URL from hyperlink 'posted by Rick Rothstein If r

blog.contextures.com