Cut last row and paste elsewhere

N

Nomadscot

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'?
 
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
 
Back
Top