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 testsplit()
Range("C:c").ClearContents
derliA = Range("A36536").End(xlUp).Row
derliB = Range("B36536").End(xlUp).Row
X = 3 'parametre a définir
Dim motA()
For Each CelA In Range("a1:a" & derliA)
MotAtemp = Split(CelA, " ")
For i = 0 To UBound(MotAtemp)
ReDim Preserve motA(i)
If IsError(Application.Match(MotAtemp(i), motA, 0)) Then
motA(i) = MotAtemp(i)
End If
Next i
For Each CelB In Range("b1:b" & derliB)
For i = 0 To UBound(motA)
MotB = Split(CelB, motA(i))
If UBound(MotB) < X And UBound(MotB) >= 1 Then CelA.Offset(0, 2) = CelA.Offset(0, 2) & motA(i) & "_" & CelB.Row & "."
Next i
Next CelB
ReDim motA(0)
Next CelA
End Sub |
Partager