Thread: How to copy the url for a list of cell with hyperlinks in another column?

How to copy the url for a list of cell with hyperlinks in another column?

With the hyperlinks in Col A run this to copy the address in Col B

Sub Test()
Dim hlnk As Hyperlink
For Each hlnk In Columns("A").Hyperlinks
hlnk.Parent.Offset(0, 1).Value = hlnk.Address
Next
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"jaya" <jayap@wanadoo.fr> wrote in message news:4347b4a1$0$27414$8fcfb975@news.wanadoo.fr...
> How to copy the url for a list of cell with hyperlinks in another column?
>