I'm coming to you to ask for some help with this code :
Option Explicit
Dim lgn&
Dim plage1 As Range, plage2 As Range
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
lgn = Target.Row
Set plage1 = Range("C" & lgn & ",E" & lgn & ",G" & lgn...