Cut last row and paste elsewhere

Joined
Jan 2, 2014
Messages
5
Reaction score
0
I wonder if someone can help me with this VBA problem please.

I need to 'Cut' a Range which starts from the last populated cell in column A to the last populated cell in Column T.

I then need to paste those 'Cut' cells elsewhere on the same sheet.

How can I select the Range to be 'Cut'?
 
Joined
Feb 21, 2018
Messages
216
Reaction score
86
This code selects the last populated cell in column A
Range("A" & ActiveSheet.Rows.Count).End(xlUp).Select

And the following code extends the selection upto the last populated cell in column T

Range(Selection, Range("T" & ActiveSheet.Rows.Count).End(xlUp)).Select
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top