Hi Guys, I'm trying to write the following formulae:

ActiveCell.FormulaR1C1 = "=SUM(R[-50]C:R[-1]C)"
The number of rows varies dependent on the data extracted so I want to replace the -50 with a variable "finalrow". I did the following:-

ActiveCell.FormulaR1C1 = "=SUM(R[1-finalrow]C:R[-1]C)"
However, this gives an error. I've played around a bit but can't get it to work. Can you advise me of the correct syntax please,

thanks,

Neil