Bonjour,
Un exemple.
Cdlt.
Public Sub CopyData()
Dim ws As Worksheet, ws2 As Worksheet
Dim Cell As Range, n As Long
Const R As String = "C5:E8"
Set ws = Worksheets("Feuil1")
Set ws2 = Worksheets("Feuil2")
n = IIf(IsEmpty(ws2.Cells(2, 2)), 2, ws2.Cells(Rows.Count, 2).End(xlUp).Row + 2)
ws.Range(R).Copy Destination:=ws2.Cells(n, 2)
End Sub