If Formula Run-time error

[Glasgowsmile]

Good day,

I've got this VBA code below that I'm trying to do but I keep getting a 1004 Application-defined or object-defined error. It works fine without the IF statement so I'm not sure what the problem is within the IF statement itself.

Sheets("Sheet1").Range("E24, H24, K24, N24, Q24, T24, W24").Formula = "=IF($E$7>E12, "", (Sheet2!$I$22*$E$10)-(Sheet2!$I$22*F7))"

 

[Fluff]

You need to double-up on the quotes in side the formula

Sheets("Sheet1").Range("E24, H24, K24, N24, Q24, T24, W24").Formula = "=IF($E$7>E12, """", (Sheet2!$I$22*$E$10)-(Sheet2!$I$22*F7))"