Pasting a range of cells in excel n number of times (VBA)

[qasimmalik]

Hi, I'm very new to VBA and was hoping I can get some help here.

I have a range of cells (A1:R4) that I would like to copy and paste right below one another a set number of times (2357 times to be exact).

Any help is appreciated. Thank you!

 

[Fluff]

How about

Sub CopyMultiple()
Range("A1:R4").Copy Range("A5").Resize(4 * 2357, 18)
End Sub

 

[qasimmalik]

Works like a charm, you ARE an MVP!

 

[Fluff]

Glad to help & thanks for the feedback