Hi guys.
How can I make this code working? It should take cell from rng2, go through first row in rng1, compare it and if it doesn't find match, paste this cell in somewhere (destination is irrelevant).
Dim FirstRow As Variant, rng1 As Range, rng2 As Range, FRow As Range, j As Integer
Set FirstRow = rng2.Rows(1)
Set FRow = rng1.Rows(1)
For j = LBound(FirstRow) To UBound(FirstRow)
If Intersect(j, FRow) Is Nothing Then
Selection.Copy Destination:=Range("A1").End(xlToRight).Offset(0, 1).Paste
Else
End If
Next j
Thanks
Bookmarks