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
HIS


"john_liu" wrote in message
...
How can I copy an entire row into the next row by a macro. Thanks for your
help.