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


Replace the " in your code by  "&CHR(34)&"

 Other excel answers



You can find similar Excel Questions and Answer hereunder

1) How can I add Trendline to a chart using VBA?

2) How can I convert Column numbers into Column names for use in range definition?

3) How can I copy and rename a WorkSheet using VBA?

4) How do I copy a Table from one location to another and retain all formulas, formats and columnwidths?

5) How to do worksheet protection with VBA in Excel

6) How can I set the Source Data of charts using VBA?

7) How can I check if a file exists in a folder using VBA?

8) How can I get row count of filtered data?

9) Userform initialize vs userform show in Excel

10) How can I dynamically add a hyperlink using VBA?


Here the previous and next chapter