I know this is simple but I am not sure of the syntax to do this, here is what I hav

LastActiveRowForNames = Cells(Rows.Count, "B").End(xlUp).Ro
Range("G" & LastActiveRowForNames + 1).Selec
ActiveCell.FormulaR1C1 = "=SUM(R[-LastActiveRowForNames]C:R[-1]C)" <---problem her

In this I a basically putting a sum at the bottom row of column "G" to sum it. I won't know what the bottom row is so I have it set as "LastActiveRowForNames" then I add one to it to make the active cell the one at the bottom of column G. Then I want to sum it but it doesn't like what I have. I know the idea is right, I think I am just wrong on syntax.

Any help would be greatly appreciated, I know its simple, I just don't know the answe

Jim