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 filtre(feuille As String)
Dim i As Integer ', Tabl() As Range
'Tabl = WorksheetFunction.Transpose(Range("A2:A450"))
Set rang = Worksheets(feuille).Range("A2:A450")
Tabl = Application.WorksheetFunction.Transpose(rang)
'Do
With ListBox4
.AddItem Tabl(1)
For i = 2 To UBound(Tabl)
If Tabl(i) = "" Then
Tabl(i) = "VIDE"
End If
If WorksheetFunction.Match(Tabl(i), Tabl, 0) = i Then .AddItem Tabl(i)
' If Worksheets("FichierCentral").Match(Tabl(i), Tabl, 0) = i Then .AddItem Tabl(i)
Next
'Loop While
End With
End Sub |
Partager