Expressing a " in an excel Formula as VBA code

[Onjslnjps]

Hi, I'm really in need of some help with the following. I have an excel formula I want to translate into VBA code. The formula contains quotation marks so is returning an error when testing. How do I get VBA to read the quotation marks as quotation marks and not as the start/end of a line?

Thanks

 

[Richard Schollar]

Hi

Double them up:

Range("A1").Formula = "=IF(B1=""Yes"",""Answer was yes"",""Answer was no"")"