Using LastColumn in a VBA Formula

[stirlingmw1]

Morning All

I am trying to add the formula "=Sum(from:to)" into a column within my worksheet. I can get the formula to work if I use column letters but i want to be able to add LastColumn into the formula.

the code I am using at present that works is:

Sheets("Minor_22-23").Range(Cells(3, LastColumn), Cells(lastrow, LastColumn)).Formula = "=Sum(C" & ActiveCell.Row + 1 & ":Y" & ActiveCell.Row + 1 & ")"

what I want to do is use the formula =Sum(C" & ActiveCell.Row + 1 & , but where ":Y" is the column being used as the final column I want to use LastColumn & ActiveCell.Row + 1 & ")". but this final change doesnt work.
I have

Dim LastColumn as Long 
LastColumn = Sheets("Minor_22-23").Cells(1, Sheets("Minor_22-23").Columns.Count).End(xlToLeft).Column

The reason I want the LastColumn referenced is that the formula could move left or right in the worksheet and I would like the formula to adjust also. What am i doing wrong?

Regards

Steve

 

[Fluff]

How about

With Sheets("Minor_22-23")
   .Range(.Cells(3, LastColumn), .Cells(lastrow, LastColumn)).FormulaR1C1 = "=Sum(RC3:RC[-1])"
End With

 

[stirlingmw1]

How about

With Sheets("Minor_22-23")
   .Range(.Cells(3, LastColumn), .Cells(lastrow, LastColumn)).FormulaR1C1 = "=Sum(RC3:RC[-1])"
End With

Thank you, works great.

The speed of reply is appreciated.

Regards

Steve

 

[Fluff]

You're welcome & thanks for the feedback.