Gidday
I have defined a variable as an integer and now wish to make a sum of that integer but am just having no joy. Any help, the code is below.
Dim Finalrow As Integer
Selection.End(xlDown).Select
Finalrow = ActiveCell.Row
Range("C2").Select
ActiveCell.Offset(Finalrow + 1, 0).Select
ActiveCell.FormulaR1C1 = "=SUM(R[- Finalrow ]C:R[-1]C)"
I have defined a variable as an integer and now wish to make a sum of that integer but am just having no joy. Any help, the code is below.
Dim Finalrow As Integer
Selection.End(xlDown).Select
Finalrow = ActiveCell.Row
Range("C2").Select
ActiveCell.Offset(Finalrow + 1, 0).Select
ActiveCell.FormulaR1C1 = "=SUM(R[- Finalrow ]C:R[-1]C)"