Sub copier() Sheets("Feuil2").Select Range("A1:A25").Select Range(Selection, Selection.End(xlDown)).Select Selection.Copy Sheets("Feuil1").Select Range("A4:A28").Select Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False End Sub