Sub Copie()
Application.ScreenUpdating = False
Set wf = WorksheetFunction
Set f = Sheets("Facture")
Set h = Sheets("Historique Facture")
nb_f = wf.CountA(f.Range("a:a")) - 2
nb_h = wf.CountA(h.Range("a:a"))
f.Range("B10:G" & 9 + nb_f).Copy
h.Range("a1").Offset(nb_h, 0).PasteSpecial Paste:=xlPasteValues, _
Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
End Sub