Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Call effacer
End Sub
Private Sub effacer()
Dim i As Long
Application.Calculation = xlCalculationManual
With Sheets("feuil1") ' a adapter a ton cas
If .Cells(5, 14).Value = 0 Then
For i = 5 To .Range("o" & .Rows.Count).End(xlDown).Row - 1 ' a adapter
.Cells(i, 15).Value = ""
If .Cells(i, 14).Value = "" Then Exit Sub
Next i
End If
End With
Application.Calculation = xlCalculationAutomatic
End Sub