Sub Copie_tableau_job75_colB_avecA()
Dim F As Worksheet, tablo, i&, n&, j%, t0
t0 = Timer
Set F = Feuil4
tablo = Feuil1.Range("A2:D" & Feuil1.Cells(Rows.Count, 2).End(3).Row)
ReDim tb(1 To UBound(tablo, 1), 1 To 3)
'--- remplir tablo si valeur en colonne B > 148
For i = 2 To UBound(tablo, 1)
If tablo(i, 2) > 148 Then
n = n + 1
For j = 2 To 4
tb(n, j - 1) = tablo(i, j)
Next
End If
Next
'--- restitution
If n Then F.[a2].Resize(n, 3) = tb
F.Visible = xlSheetVisible
Application.Goto F.[A1], True
MsgBox Format(Timer - t0, "0.000_sec")
End Sub