Sub Remplissage_bis()
'code initial de job75
Dim dL&, i&, tablo
dL = Cells(Rows.Count, 1).End(xlUp).Row
If dL = 1 Then Exit Sub
tablo = [A1].Resize(dL, 1) 'matrice, plus rapide
For i = 2 To dL
If Trim(tablo(i, 1)) = "" Then
tablo(i, 1) = tablo(i - 1, 1)
End If
Next
[A1].Resize(dL) = tablo
End Sub