On Sun, 5 May 2013 15:01:38 +0200, Claus Busch
wrote:
Hi Jesper,
modify following code to suit:
Sub CopyHyperlinks()
Dim rngC As Range
Dim c As Range
Dim LRow As Long
With Sheets("Sheet2")
LRow = .Cells(.Rows.Count, "A").End(xlUp).Row
For Each rngC In .Range("A1:A" & LRow)
Set c = Sheets("Sheet1").Range("A1:A300") _
.Find(rngC, LookIn:=xlValues)
If Not c Is Nothing Then
c.Offset(0, 1).Copy rngC.Offset(0, 1)
End If
Next
End With
End Sub
Regards
Claus Busch
Hi Claus
Thanks a lot! Your code does what I want done. I can't say that i
understand the code, but it is easy to modify it to do what I need to
do, and look at the rest as a "black box".
Best regards
--
Jesper Kaas -