How can I use the " character in a string

[Guest]

I'm programming a macro in Visual Basic and want the macro to insert a
formula in the worksheet using the ActiveCell.FormulaR1C1 property. I want
the formula to include an empty string, like this:
=IF(ISBLANK(A1);A1+8;"")
so that the cell is empty if A1 is blank, and otherwise the result of the
formula.

ActiveCell.FormulaR1C1 = "=IF(ISBLANK(A1);A1+8;"")"
is what I have attempted, but obviously this won't work as the " character
will end and restart the string without leaving " characters. How can I go
about having the " character included in the string?

 

[Gary Keramidas]

try this, i change the semi colons to commas, though. you need to double up on
the quotes

ActiveCell.Formula = "=IF(ISBLANK(A1),A1+8,"""")"

 

[aidan.heritage]

When you have a problem like this one, it's always worth using the
macro recorder to see what is generated - in this instance, it would
give you EXACTLY what you needed - also, worth mentioning that
formulaR1C1 would need R1C1 instead of A1 (if you want to use A1,
change it to just Formula