Hi,

I'm trying to add a forumla every three cell in the range of R4:R414 with offset.

not sure how to insert the formula every time

[VBA]Range("R4").FormulaR1C1 = "=R[-2]C[-1]+RC[-1]"
ActiveCell.Offset(3, 0).Select
[/VBA]


Thank you for your time

Nurofen