Copy a range severally downwards

[panyagak]

Hi Mrexcel experts

Am figuring out how to copy a range of cells, say A1:U458, downwards severak times, eg. 23 (less or more) with the next copy being A460: WITH AN EMPTY ROW SEPARATING EACH COPY.

thanks
Patrick

 

[Cross Terrier]

Highlight all the data PLUS THE NEXT BLANK LINE BELOW IT, copy and paste into A460 then A920 then however many other times. Hold down Ctrl and Shift and press the down arrow to get to the bottom of each block of data each time.

Or did you want this to be done with a macro?

 

[panyagak]

Cross Terrier

Thats what I do MANUALLY!! (even if 30 times!!)

I need to cut that out

I hoped a vba code can do that!!

 

[panyagak]

This link only needs a little modification. My problem is copy paste a range WITHIN THE SAME SHEET.

https://www.mrexcel.com/forum/excel-questions/378563-copy-paste-range-multiple-times.html

 

[Joe4]

Try this:

Sub MyCopyMacro()

    Dim myRange As Range
    Dim i As Long
    
    Application.ScreenUpdating = False
    
'   Set range to copy
    Set myRange = Range("A1:U458")

'   Copy 23 times
    For i = 1 To 23
        myRange.Copy Cells((i * 459) + 1, "A")
    Next i
   
    Application.ScreenUpdating = True
    
    MsgBox "Copy Complete!"
    
End Sub

 

[panyagak]

Thanks Joe4.

I trust you on this as you've solved my nagging vba issues previously WITH SUCCESS!!!

Cheers

 

[panyagak]

Joe4

You are a SUPERMAN, EXPERT!! YOU MADE MY 2017!!

Thanks

 

[Joe4]

You are welcome. Glad it worked for you!