I am trying to create a simple loop that inserts a formula but I seem to be missing something. I want to:
1) Find the last row with data in it
2) Starting in cell T3 and looping all the way down to the last row I want to insert a formula
3) The formula should be the sum of colums F through S.
What am I missing?
Dim lstrow As Integer
Dim i As Integer
Application.ScreenUpdating = False
lstrow = Cells(Rows.Count, 1).End(xlUp).Row
For i = lstrow
Range("T3" & lstrow).Formula = "=SUM(RC[-14]:RC[-1])"
Application.ScreenUpdating = True