VBA to add a formula that includes a question mark: Compile error

[Tarver]

I'm trying to use VBA to replace some formulas in a spreadsheet when the user requests them. One of those should include question mark (?). I know this is a wildcard, but it works within my formula, not in VBA.

Range("B14").Formula = "=IF($D14<>"","?","")"

I get the error "Compile Error: Expected: End of statement," and my question mark is highlighted.

If I precede question mark with a tilde, like so, I get a slightly different error: "Compile error: Invalid character."

Range("B14").Formula = "=IF($D14<>"","~?","")"

How can I force VBA to think that the ? is a text character and not a wildcard?

Thanks in advance!

 

[Fluff]

You need to double-up the quotes inside a string like

Range("B14").Formula = "=IF($D14<>"""",""?"","""")"

 

[Tarver]

Ah, the ol' double-quotes! Thank you Fluff, as always!

 

[Fluff]

Glad to help & thanks for the feedback.

 

[Tarver]

One more follow-up, Fluff. I am most definitely not a programmer. I had another issue come up today where I was trying to insert a formula and had another error. I was using quotes, like yesterday, and used this solution to know that I needed to double the quotation marks that are inside of my quotation marks in my VBA.

So, your answer is still paying dividends for me. Thanks again!

 

[Fluff]

Glad it helped.