I Have a macro containing a line that will change the formula of a cell using R1C1 formula type.
The formula is:
ActiveCell.FormulaR1C1 = _ "=IF(RC[-2]=0,"",(RC[-20]-RC[-16]))"
When ever I attempt to run the macro it always comes up with a dialog box saying
Run-time error '1004': Application-defined or object-defined error.
And when you click debug it highlights those 2 lines in the macro. And I can't figure out how to fix it. Can anyone help?