how to copy entire row into next row
 

how can i copy an entrie row into the next row by macro. Thanks for your
help

how to copy entire row into next row
 

Rows("1:1").Copy Destination:=Rows("2:2")

"john_liu" wrote in message
...
how can i copy an entrie row into the next row by macro. Thanks for your
help

how to copy entire row into next row
 

this will copy the active row down one

Sub copyentirerow()
Rows(ActiveCell.Row).Copy Rows(ActiveCell.Row + 1)
End Sub

--
Don Guillett
SalesAid Software

"john_liu" wrote in message
...
how can i copy an entrie row into the next row by macro. Thanks for your
help