Thread: Copy and Paste Macro that pastes to the next open row

Please wrap your code in code tags, before the moderators get you...

Forum rules

3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # button at the top of the post window. If you are editing an existing post, press Go Advanced to see the # button.

Cheers

Then try this

Sub moveit()
    Dim LastRow As Long
    
    LastRow = Range("E" & Rows.Count).End(xlUp).Row
    
    Range("E7:CZ7").Copy
    Range("E" & LastRow + 1).PasteSpecial Paste:=xlPasteValues, _
                        Operation:=xlNone, SkipBlanks:=False, Transpose:=False
End Sub

Hope this helps.

If you need any further information, please feel free to ask further

However

If this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody!
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.

Awesome, thanks so much!

(and thanks for telling me about the forum rule, I didn't know!)

Wrong tags!!!
Use the # symbol for code, it keeps the BB tidy, and your code easier to recognise

None-the-less
Happy to have helped.