Private Sub Worksheet_Change(ByVal Target As Range)
Dim plage As Range
On Error Resume Next 'si aucune cellule vide en colonne G
Set plage = [G1:G500].SpecialCells(xlCellTypeBlanks)
Application.EnableEvents = False 'désactive l'action des événements
Intersect([B:I], plage.EntireRow).ClearContents
Application.EnableEvents = True
End Sub