Sub Incrementer()
With ActiveSheet
If .FilterMode Then .ShowAllData 'si la feuille est filtrée
With .Range("A2:B" & .Cells.SpecialCells(xlCellTypeLastCell).Row)
If .Row < 2 Then Exit Sub
.Columns(1) = "=IF(RC[1]="""","""",MAX(R1C:R[-1]C)+1)"
.Columns(1) = .Columns(1).Value 'supprime les formules
End With
End With
End Sub