repeating macro

[Frankeyy]

Hi, i want to repeat this macro 2119 times, but from cell c5 it need to paste 5 rows down, so it has to past in C10, C15, C20 etc. until thats 2119 times done.

how can i do that?

this is the macro.

Range("C5").Select
Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlToRight)).Select
Selection.Copy
Range("C10").Select
ActiveSheet.Paste
Application.CutCopyMode = False

Plz help

 

[BrianMH]

Ok. Is the selection range fixed? As in I notice you go from C5 down and right. Is this area fixed and if so what is that range? Also are you copying the same range every time or is the copy portion meant to change?