Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Column = 4 Then
Rows(Target.Row).Copy
With Sheets("Feuil2")
.Rows(1).PasteSpecial xlPasteValues 'collage spécial
Application.Goto .[A1], True 'cadrage
End With
Application.CutCopyMode = 0
End If
End Sub