Tuesday, September 25, 2018

Excel- Find Url from LInk

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

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)