Hello Darren,
Here is a macro that will that will list the link address of all
hyperlinks on the active worksheet. The hyperlink address is placed in
the cell immediately to the right of the hyperlink.
Code:
--------------------
Sub ListLinkAddresses()
Dim Addx, HypLnk
With ActiveSheet
For Each HypLnk In .Hyperlinks
Addx = .Range(HypLnk.Range.Address).Offset(0, 1).Address
.Range(Addx).Value = HypLnk.Address
Next HypLnk
End With
End Sub
--------------------
Sincerely,
Leith Ross
--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile:
http://www.excelforum.com/member.php...o&userid=18465
View this thread:
http://www.excelforum.com/showthread...hreadid=493957