Extract URL from hyperlink using VBA

Hello friends!! We’ll be learning to extract the URL from hyperlink using VBA function.

VBA code to use

Function ExtractURL(rng As Range) As String
On Error Resume Next
ExtractURL= rng.Hyperlinks(1).Address
End Function

Use the function

ExtractURL(A1)

Keep visiting Analytics Tuts for more tutorials.

Thanks for reading! Comment your suggestions and queries