Iferror VBA not working

[ExcelHobbit]

I have the following VBA formula, which is not working. if i just have the formula in a cell, it works just fine:

Range("AI4").Select
ActiveCell.FormulaR1C1 = "=IFERROR(RC[-3]/(RC[-15]-RC[-24]), "")"

as a formula it would just be =iferror(AF4/(T4-K4), "")

 

[RoryA]

You need to double any quotes that are part of the formula string:

ActiveCell.FormulaR1C1 = "=IFERROR(RC[-3]/(RC[-15]-RC[-24]), """")"

 

[ExcelHobbit]

perfect thanks

 

[RoryA]

Glad to help.