Sub Ajout_recap()
Dim ligVide As Long
With Sheets("Récap")
ligVide = .Range("A" & Rows.Count).End(xlUp).Row + 1
.Cells(ligVide, 1).Value = ActiveSheet.Range("E8")
.Cells(ligVide, 2).Value = ActiveSheet.Range("E7")
.Cells(ligVide, 3).Value = ActiveSheet.Range("E6")
.Cells(ligVide, 4).Value = ActiveSheet.Range("E3")
End With
End Sub