Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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?
|
#2
|
|||
|
|||
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" wrote in message ... How to copy the url for a list of cell with hyperlinks in another column? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a List inside a cell? | Excel Discussion (Misc queries) | |||
How can I copy values from one cell in a column down to the next c | Excel Discussion (Misc queries) | |||
copying cell names | Excel Discussion (Misc queries) | |||
How can I copy cell formats in functions? | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions |