Hallo Nick,
Option Explicit
Sub nick()
Dim LoLetzte As Long
Dim Loi As Long
' letzte belegte Zeile unabhängig von Excelversion für Spalte A (1)
LoLetzte = IIf(IsEmpty(Cells(Rows.Count, 1)), Cells(Rows.Count, 1).End(xlUp).Row, Rows.Count)
If Cells(1, 1) <> "" Then Cells(1, 1) = 426
For Loi = 2 To LoLetzte
If Cells(Loi, 1) <> "" Then
If Application.WorksheetFunction.Max(Range("D1:D" & Loi - 1)) < 426 Then
Cells(Loi, 4) = 426
Else
Cells(Loi, 4) = Application.WorksheetFunction.Max(Range("D1:D" & Loi - 1)) + 1
End If
End If
Next Loi
End Sub
Gruß Hajo