Extracting a URL from a hyperlink on Excel

C

Costas

Administrator
Staff member
JavaScript: 
'src - https://howtouseexcel.net/how-to-extract-a-url-from-a-hyperlink-on-excel
Sub Button1_Click()
    Dim HL As Hyperlink
    
    For Each HL In ActiveSheet.Hyperlinks
        HL.Range.Offset(0, 1).Value = HL.Address
    Next
End Sub
 
You must log in or register to reply here.
Top