Sub Macro1()
'
' Macro1 Macro
'
'
Sheets("Feuil2").Select
Range("A3:A8").Select
ActiveWorkbook.Names.Add Name:="Clients", RefersToR1C1:="=Feuil2!R3C1:R8C1"
ActiveWorkbook.Names("Clients").Comment = ""
Sheets("Feuil1").Select
Columns("A:A").Select
With Selection.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="=Clients"
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = ""
.ShowInput = True
.ShowError = True
End With
End Sub