izazueta/GetURL.txt

Created February 12, 2015 23:13

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/izazueta/01179273fd7ee85a0ac4.js"></script>
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

	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