Skip to content

Instantly share code, notes, and snippets.

@themegabyte

themegabyte/GetURL.bas

Last active June 13, 2021 13:37
Show Gist options
  • Save themegabyte/a5dc02e9c9e636f1db19c9d210be7426 to your computer and use it in GitHub Desktop.
Save themegabyte/a5dc02e9c9e636f1db19c9d210be7426 to your computer and use it in GitHub Desktop.
Download ZIP
Excel function to extract HyperLinks from linked cell.
Raw
GetURL.bas
Function GetURL(rng As Range) As String
On Error Resume Next
GetURL = rng.Hyperlinks(1).Address
End Function
' Usage: GetURL(Cell Number)
' Output: Associated address with Cell Number
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment