How to copy entire row into next row by macro

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

john_liu

How can I copy an entire row into the next row by a macro. Thanks for your
help.
 
John

I doubt this is the full extent of your request, but to do literally what
you ask. Works by copying entire row of the selected cell(s)

Sub CopyToRowDown()
Selection.EntireRow.Copy Destination:=Selection.Offset(1, 0)
End Sub

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
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

Can I send an email too? 3
MACRO to paste row into next empty row 0
Inserting additional rows and only copying certain columns 1
If Cell = X, Then Copy Entire Row Into A New Sheet 5
Delete Entire Row 4
Breaking One Row into Multiple Rows using VBA Macro? 2
Make Macro Work On A Different PC 5
Searching for a word and then copy the whole row 5

Back
Top