Set Formula For Range

[IREALLYambatman]

Hey guys, I'm just basically failing at a really easy task.. I think. I just need to to set the cells to the formula below increment for the range.. I'm kinda stuck.


'Worksheets("Log").Range("6D:35D").Formula = " =IF(A6<>"", B6-C6, "")"

 

[IREALLYambatman]

Got it!

Worksheets("Log").Range("D6:D27").FormulaR1C1 = "=IF(RC[-3]<>"""", RC[-2]-RC[-1], """")"