Sub Modif()
Dim i As Long
code = [C16]
With Sheets("Liste")
i = Application.Match(code, Feuil2.[E1:E65000], 0) 'indique le N° ligne
If Not IsNumeric(i) Then MsgBox "annuler": Exit Sub
.Cells(i, 2).Value = [C10] 'Acteur 1
.Cells(i, 3).Value = [C12] 'Acteur 2
.Cells(i, 4).Value = [C14] 'Genre
.Cells(i, 5).Value = [C16] 'Support
.Cells(i, 1).Value = [C6] 'C ou O
End With
Application.EnableEvents = False
[C6:C16].ClearContents
Application.EnableEvents = True
End Sub