Quotation Marks Causing Error

[Excel Jr]

I'm trying to get excel to put a formula into a cell. This works fine with text and simple formulas.

Sheets("Sheet1").Range("D11").Formula = "=SUM(A1:A20)"

However I need it to print the following into the cell ad the quotation marks are giving me errors.

Sheets("Sheet1").Range("D11").Formula = "=IFERROR(VLOOKUP(A12,Sheet2!E:F,2,FALSE),[COLOR=#ff0000]""[/COLOR])"

Does anyone know any workarounds, I need the formula the way it is. Is there another way to notate that it should return nothing or a blank?

Thanks!

 

[Fluff]

You need to double up all quotes within the formula, so it should be

Sheets("Sheet1").Range("D11").Formula = "=IFERROR(VLOOKUP(A12,Sheet2!E:F,2,FALSE),[COLOR=#ff0000]""""[/COLOR])"

 

[Excel Jr]

Awesome! Thank you!

 

[Fluff]

You're welcome