1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| Sub test()
Dim c As Range, Txt1, Txt2, TablC, TablG
[C:C].Copy [J1]
[G:G].Copy [K1]
[J:J].Replace " ", "*!*", xlPart
[J:J].Replace "-", "*!*", xlPart
[K:K].Replace " ", "*!*", xlPart
[K:K].Replace "-", "*!*", xlPart
For Each c In Range([J1], Cells(Rows.Count, 10).End(xlUp))
If c.Value <> "" And c.Offset(, 1).Value <> "" Then
Txt1 = Split(c.Value, "*!*")
Txt2 = Split(c.Offset(, 1).Value, "*!*")
For Each Item In Txt1
If IsNumeric(Application.Match(Item, Txt2, 0)) Then
c.Offset(, -2).Value = 1
Cells(c.Row, 3).Interior.ColorIndex = 43
Cells(c.Row, 7).Interior.ColorIndex = 43
Exit For
End If
Next Item
End If
Next c
[J:K].Clear
End Sub |
Partager