Sub test()
Dim I As Integer
Dim X As Byte
X = Sheets("modifier").Range("D4").Value + 2
With Sheets("donnees")
.Rows(X).Delete shift:=xlShiftUp
For I = X To 247
If .Range("A" & I).Value <> "" Then
.Range("A" & I).Value = .Range("A" & I).Value - 1
End If
Next I
End With
End Sub