Option Explicit
Sub Dupliquer()
Application.ScreenUpdating = False
Sheets("Feuil1").Range("a9").Resize(Range("b1")).EntireRow.Copy
With Sheets("Feuil2"): .Range("a" & Rows.Count).End(xlUp)(2).PasteSpecial Paste:=xlPasteValues: End With
Application.CutCopyMode = False
Application.ScreenUpdating = True
End Sub