Salut,
Creepy un autre exemple, je fais tout par tableau:
Sub Creepy()
Dim T, Qui(), Tabres()
Dim Test As Boolean
Dim I&, J&, K&
T = Range([A1], [A65536].End(xlUp)).Value
Qui = Array("dede", "titi","dudule")
K = 1
For I = 1 To UBound(T)
For J = 0 To UBound(Qui)
If T(I, 1) = Qui(J) Then
T(I, 1) = ""
Exit For
End If
Next J
If T(I, 1) <> "" Then
ReDim Preserve Tabres(1 To 1, 1 To K)
Tabres(1, K) = T(I, 1)
K = K + 1
Test = False
End If
Next I
T = InverseTab(Tabres, 1)
[A1].Resize(UBound(T)) = T
End Sub
Function InverseTab(T, Optional Base As Byte = 0)
Dim Temp(), I&, J&
ReDim Temp(Base To UBound(T, 2), Base To UBound(T))
For I = LBound(T, 2) To UBound(T, 2)
For J = LBound(T) To UBound(T)
Temp(I, J) = T(J, I)
Next J
Next I
InverseTab = Temp
End Function
Pour un tableau sur plusieurs colonnes il faudra rajouter une boucle.
A+++
Lien supprimé