I need to sum from a specific point(d14) down a column various lengths depending on a user input. If the user inputs say 5, I need something along the lines of:
ActiveCell.FormulaR1C1 = "=SUM(R14C:R[num]C)"
The 'num' is defined from a userform and could be any number they put in.
ActiveCell.FormulaR1C1 = "=SUM(R14C:R[num]C)"
The 'num' is defined from a userform and could be any number they put in.