VB To Copy Last Column Of Table To The Next Cell To The Right

I'm trying to find the last column of my table that will change from week to week and copy the contents of that cell and the one beneath it and paste them into the two cells to the right of them.

Here's what I've tried:

Sheets("LY - TY Chart - Tot. Sell $").Select

Dim lastTableColLY As Long
Dim lastTableColTY As Long
Dim nextTableColLY As Long
Dim nextTableColTY As Long

lastTableColLY = Cells(109, Columns.Count).End(xlToLeft).Column
lastTableColTY = Cells(110, Columns.Count).End(xlToLeft).Column

Range.Cells(lastTableColLY, lastTableColTY).Select.Copy
Range.Cells(nextTableColLY).Select.Paste

I'm getting the following error:

Compile error: Argument not optional at the
Range.Cells(lastTableColLY, lastTableColTY).Select.Copy