Hi,
I'm new to VBA, self taught from what I've read online and from recording marcos.

I have a spreadsheet that I need to insert a new column between the last column of data and the totals column.
The date row is on row 5 so just find the last column in that row and it gives me that last column.

That bit I can do.

I then need to autofill the formulas across from last column into the new column. I'm struggling to get this bit to work.
Below is what I have that works so far, I'm just now sure how to select the destination of the autofill.

Sub NewMonth()

Dim NewC As Long
Dim LastC As Long

'find last column

LastC = Cells(5, Columns.Count).End(xlToLeft).Column

'label the new column
NewC = Cells(5, Columns.Count).End(xlToLeft).Column + 1

'create new column
Columns(NewC).Select
Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFillDefault

'copies the row across
Columns(LastC).Select
Selection.AutoFill Destination:=Columns(LastC & ":" & NewC), Type:=xlFillDefault

End Sub