How do i put double quotes in a string in vba in Excel
I want to insert an if statement in a cell through vba which includes double
quotes.
Here is my code:
Worksheets("Sheet1").Range("A1").Value =
"=IF(Sheet1!B1=0,"",Sheet1!B1)"
Due to double quotes I am having issues with
inserting the string. How do I handle double quotes
Answer:
Replace the " in your code by "&CHR(34)&"