dim rngCopy as range, rngPaste as range
set rngCopy = thisworkbook.worksheets("worksheetname").range("A50").entirerow
set rngPaste - thisworkbook.worksheets("anotherworksheetname").range("A50").entirerow
dim rngCopy as range, rngPaste as range
set rngCopy = thisworkbook.worksheets("worksheetname").range("A50").entirerow
set rngPaste - thisworkbook.worksheets("anotherworksheetname").range("A50").entirerow
Yep - i just used "a50" as a example, you can use whatever number you need, or, set up some method (which I haven't addressed at all yet) to determine dynamically which is last row