| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy & paste block of text number of times equal to value in cell | Excel Worksheet Functions | |||
| Macro - copy a range and paste it in a new sheet 12 times | Excel Worksheet Functions | |||
| copy and paste using macro | Excel Discussion (Misc queries) | |||
| Copy and Paste using macro | Excel Discussion (Misc queries) | |||
| macro to copy a value multiple times depending on value in adj | Excel Worksheet Functions | |||
Linear Mode
