Sub test1()
Dim LI As Integer
LI = Cells(Application.Rows.Count, "A").End(xlUp).Row
Rows(LI).Insert Shift:=xlDown
If LI < 3 Then Exit Sub
Cells(LI - 2, "A").Copy
Cells(LI, "A").PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
With Cells(LI, "B").Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="=LISTES!$A$204:$A$217"
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = "Sélectionner option"
.ErrorMessage = ""
.ShowInput = True
.ShowError = True
End With
End Sub[\code]