With Application
.ScreenUpdating = False
With Feuil2
.Range([B1], [B65536].End(xlUp)).AutoFilter 1, "="
.AutoFilter.Range.Offset(1, -1).SpecialCells(xlCellTypeVisible).Copy Feuil1.[A1]
.AutoFilterMode = False
End With
Feuil1.Activate
.ScreenUpdating = True
End With