Skip to content

Instantly share code, notes, and snippets.

@izazueta

izazueta/GetURL.txt

Created February 12, 2015 23:13
Show Gist options
  • Save izazueta/01179273fd7ee85a0ac4 to your computer and use it in GitHub Desktop.
Save izazueta/01179273fd7ee85a0ac4 to your computer and use it in GitHub Desktop.
Download ZIP
VBA code to get URL from text in Excel Author: Ellesa (https://superuser.com/a/430410/98967)
Raw
GetURL.txt
VBA Module
Public Function GetURL(c As Range) As String
On Error Resume Next
GetURL = c.Hyperlinks(1).Address
End Function
In Excel cell
=GetURL(A1)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment