honzapav/gist:1ed434985ea9133679d8

Created November 28, 2015 12:34

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/honzapav/1ed434985ea9133679d8.js"></script>
Save honzapav/1ed434985ea9133679d8 to your computer and use it in GitHub Desktop.

Download ZIP

VBA extract URL from link

Raw

gistfile1.txt

	Sub ExtractHL()
	Dim HL As Hyperlink
	For Each HL In ActiveSheet.Hyperlinks
	HL.Range.Offset(0, 1).Value = HL.Address
	Next
	End Sub

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment