1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| Sub exemple()
Dim Dl As Range, Tbl, tblFiltre(), x As Long, NbF As Long, y As Long
y = 0
With Sheets("Feuil1")
Set Dl = .Range("A" & .Rows.Count).End(xlUp)
Tbl = .Range("A2", Dl)
'filtre demandé
NbF = WorksheetFunction.CountIf(.Range("A2", Dl), "le filtre")
ReDim tblFiltre(1 To NbF, 1 To 2)
For x = 1 To UBound(Tbl, 1)
If Tbl(x, 1) = "le filtre" Then
y = y + 1
tblFiltre(y, 1) = Tbl(x, 1)
tblFiltre(y, 2) = Tbl(x, 2)
End If
Next
End With
Sheets("Feuil2").Range("A2").Resize(UBound(tblFiltre, 1), UBound(tblFiltre, 2)) = tblFiltre
End Sub |
Partager