The last row range of the original data set (A:E) needs to replace the last row range of a different set (T:X). What does it need to look like to copy the last row range in A:E over?
Code:
Sub pastespecial()
With ws
.Range("T:X").Copy
.Range("T1").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
.Range("A" & Cells.Rows.Count).End(xlToRight)).Copy 'code busts here
.Range("T" & Cells.Rows.Count).End(xlUp).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
End With
End Sub