how to copy entire row into next row

  • Thread starter Thread starter john_liu
  • Start date Start date
J

john_liu

how can i copy an entrie row into the next row by macro. Thanks for your
help
 
this will copy the active row down one

Sub copyentirerow()
Rows(ActiveCell.Row).Copy Rows(ActiveCell.Row + 1)
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MACRO to paste row into next empty row 0
Excel Help to copy information from one row at a time to another sheet 1
Can I send an email too? 3
How to copy entire row into next row by macro 1
Copy & Paste Only Those That Don't Exist 2
Searching for a word and then copy the whole row 5
Breaking One Row into Multiple Rows using VBA Macro? 2
Eliminate blanks while copy row and transpose 11

Back
Top