VBA Code To Paste From Last Column With Data In It To Next Column

The data exists in a spreadsheet that has Data from Column B2:CQ18, but it needs to be dynamic and update anytime someone clicks the button (the button is fine and works with all the other Macros)

Here is the code I have so far.

Code:
Dim LastCol As Range
Dim NextColPaste As Range
With Worksheets("Run Hours")
Set LastCol = Range("M3:M18").End(xlToRight)
Set NextColPaste = LastCol.Offset(, 1)
LastCol.Select
End With

That Code will Select the data in row 3 only and not the whole range of 3:18

I have tried Range (LastColData & "3:18").Select and that selects everything on the whole page from row 18 down.

I have done a lot of searching and for some reason this dynamic selection and pasting of data is escaping me this morning