Voilà (peut-être) une solution :
EDIT : j'avais oublié une partie du code
Option Explicit
Sub Ajout()
Dim BD As Worksheet
Dim Plage As Range
Dim Col As String
Dim Ajout As Long, ValeurDepart As Long, Calcul As Long, DernLig As Long, NextCel As Long
Dim Max As Integer, cpt As Integer, PremLig As Integer
Dim Cel As Object
Set BD = ThisWorkbook.Worksheets("Feuil1")
Col = "A"
PremLig = 1
DernLig = BD.Range(Col & BD.Rows.Count).End(xlUp).Row
Set Plage = BD.Range(Col & PremLig & ":" & Col & DernLig)
Ajout = Application.InputBox("Valeur à ajouter :", "Incrémentation", Type:=1)
If Ajout = 0 Then Exit Sub
Max = 10
NextCel = 1
For Each Cel In Plage
ValeurDepart = BD.Range(Col & NextCel)
cpt = 1
Calcul = BD.Cells(NextCel, cpt) + Ajout
BD.Cells(NextCel, 1) = Calcul
Do While Calcul > Max
cpt = cpt + 1
BD.Cells(NextCel, cpt) = BD.Cells(NextCel, cpt - 1) - Max
BD.Cells(NextCel, cpt - 1) = Max
Calcul = BD.Cells(NextCel, cpt)
Loop
NextCel = NextCel + 1
Next Cel
End Sub