copy row to another sheet

zezo2021

Member
Local time
Today, 10:14
Joined
Mar 25, 2021
Messages
412
friends
if I have a row number
I want to copy the entire row to last row in another sheet
how can I do that
Thank you show much
 
Use the macro recorder to get started.
Then google on how to find last row with vba, add 1 to that and paste.
 
dim rngCopy as range, rngPaste as range
set rngCopy = thisworkbook.worksheets("worksheetname").range("A50").entirerow
set rngPaste - thisworkbook.worksheets("anotherworksheetname").range("A50").entirerow

rngcopy.Copy rngPaste
 
dim rngCopy as range, rngPaste as range
set rngCopy = thisworkbook.worksheets("worksheetname").range("A50").entirerow
set rngPaste - thisworkbook.worksheets("anotherworksheetname").range("A50").entirerow

rngcopy.Copy rngPaste
That does not paste to last row, Isaac?
 
Hi Isaac

Can I use row number = 150 in range
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
 

Users who are viewing this thread

Back
Top Bottom