Sub Incremente()
Dim lig As Long, i As Long, nb As Integer, t
On Error Resume Next
nb = 1
With Feuil1
lig = .Cells(Rows.Count, 1).End(xlUp).Row + 1
Do While lig < 100
nb = nb + 1
.Range(.Cells(lig, 1), .Cells(lig, 7)) = nb
lig = lig + 1
t = Timer + 1: Do Until Timer > t: DoEvents: Loop
Loop
End With
End Sub