One more...

Activecell.entirerow.copy _
destination:=worksheets("OtherSheetNameHere").rang e("A50")

Selection could be more than one row.

Teddy-B wrote:

Help_ I need to write a macro that will copy any single row that is
highlighted and paste it to a designated row on a different worksheet
Ex.~(Row50). I am reassembling a form based upon archived data in the row
being copied.

Please help!
~Thanks

--

Dave Peterson