My current method for copying A4:M4 into X number of rows is crashing my computer. I am hoping someone might have a VBA loop that is quicker than my current method.

I need to copy A4:M4 into A5:M5,A6:M6....etc until X (rows) is reached) and then copy A5:M5.... etc and paste special back into the same cells. This can be done all in 1 function before moving to the next row.

The X (end of the loop) is defined by cell A2 and is defined by the number of rows in another sheet. My current sheet has 800k rows of data, hence I want to copy a single formula, paste into row, then copy and paste special (so the file size isn't large).

I hope this makes sense.