Private Sub Worksheet_Change(ByVal target As Range)
Dim i As Integer
Dim ligne As Integer
Dim Colonne As Integer
Colonne = target.Column
ligne = target.Row
If ligne > 5 Mod 18 And ligne < 16 Mod 18 Then
If Colonne Mod 4 = 3 And Colonne < 143 Then
Cells(ligne, Colonne + 2).Calculate
For i = 143 To 149
Cells(ligne, i).Calculate
Next i
Cells(ligne, Colonne + 3).Calculate
ElseIf Colonne Mod 4 = 0 And Colonne < 143 Then
Cells(ligne, Colonne + 1).Calculate
For i = 143 To 149
Cells(ligne, i).Calculate
Next i
Cells(ligne, Colonne + 2).Calculate
End If
End If
End Sub