Dim pasbon As Boolean
Private Sub Worksheet_Change(ByVal Target As Range)
If pasbon = False Then
If Not Application.Intersect(Target, Range('plage')) Is Nothing Then
pasbon = True
Range('A' & Target.Row & ',d' & Target.Row & ',g' & Target.Row) = Target
End If
Else
pasbon = False
End If
End Sub