ExcelBanter - copy and paste 2900 times macro

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - copy and paste 2900 times macro (https://www.excelbanter.com/excel-discussion-misc-queries/230980-copy-paste-2900-times-macro.html)

dlb

copy and paste 2900 times macro

I have 11 rows of data that I want to copy and then paste 2900 times in the
same spreadsheet. Is there a macro that will perform this function?

Jacob Skaria

copy and paste 2900 times macro

Try the below macro. Will copy the 1st 11 rows down///2900 times

Sub mac()
With ActiveWorkbook
Rows("1:11").Select
Selection.Copy
For intLoop = 1 To 2900
Range("A" & (intLoop * 11) + 1).Select
ActiveSheet.Paste
Next
End With
End Sub

If this post helps click Yes
---------------
Jacob Skaria

"DLB" wrote:

I have 11 rows of data that I want to copy and then paste 2900 times in the
same spreadsheet. Is there a macro that will perform this function?

dlb

copy and paste 2900 times macro

Worked great...thanks for the help.

"Jacob Skaria" wrote:

Try the below macro. Will copy the 1st 11 rows down///2900 times

Sub mac()
With ActiveWorkbook
Rows("1:11").Select
Selection.Copy
For intLoop = 1 To 2900
Range("A" & (intLoop * 11) + 1).Select
ActiveSheet.Paste
Next
End With
End Sub

If this post helps click Yes
---------------
Jacob Skaria

"DLB" wrote:

I have 11 rows of data that I want to copy and then paste 2900 times in the
same spreadsheet. Is there a macro that will perform this function?

All times are GMT +1. The time now is 10:14 PM.