Skip to content

Instantly share code, notes, and snippets.

@tophtucker

tophtucker/excelmacros

Created March 5, 2014 17:57
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tophtucker/9372656 to your computer and use it in GitHub Desktop.
Save tophtucker/9372656 to your computer and use it in GitHub Desktop.
Download ZIP
Excel macros
Raw
excelmacros
Function HLink(rng As Range) As String
'extract URL from hyperlink
'posted by Rick Rothstein
If rng(1).Hyperlinks.Count Then HLink = rng.Hyperlinks(1).Address
End Function
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment