VBA for Copy and paste to last row

[cufflink23]

I want to copy and paste G2:M2 to the last row in that range. How do i write the code to paste the selection to the last row, defined by column A.

 

[JackDanIce]

IvanDIP, though you private messaged me for help, have you tried njimack's suggestion in reply #2 of this thread?

What column defines your last used row?
What row do you want copied?

If only you can see your spreadsheet and you do not give sufficient details (e.g. sheet name, columns, what row number to copy), how should other people guess what you need if they can't see your PC screen?

 

[Barnes2912]

Hello all,

I have a similar question.

I would like to copy the last twos rows in my table and paste them at the bottom (but above my total row).

The difference is that I have another button already in place that will add rows in between different rows of my table whenever the button is clicked, meaning that I don't have cell references for my two last rows as they will change all of the time.

Thank you in advance!