How do I put double quotes in a string in vba?

by

I find the easiest way is to double up on the quotes to handle a quote.

Worksheets("Sheet1").Range("A1").Formula = "IF(Sheet1!A1=0,"""",Sheet1!A1)"

Some people like to use CHR(34)*:

Worksheets("Sheet1").Range("A1").Formula = "IF(Sheet1!A1=0," & CHR(34) & CHR(34) & ",Sheet1!A1)"

*Note: CHAR() is used as an Excel cell formula, e.g. writing “=CHAR(34)” in a cell, but for VBA code you use the CHR() function.

More Related Contents:

  1. Print function selecting wrong Type of Change option excel vba
  2. Format Cell Contents
  3. Excel formula checklist in employees
  4. Using a UDF in Excel to update the worksheet
  5. How to add a reference programmatically using VBA
  6. Copy Paste Values only( xlPasteValues )
  7. automatically execute an Excel macro on a cell change
  8. VLOOKUP with multiple criteria returning values in one cell
  9. VBA check if file exists
  10. How can I concatenate strings in VBA?
  11. Copy/Paste/Calculate Visible Cells from One Column of a Filtered Table
  12. Trying to use variables as values vba to sql
  13. How to call a macro from a button and pass arguments
  14. Obtain attribute names from XML using VBA
  15. VBA (Excel) Dictionary on Mac?
  16. Paste Excel range in Outlook
  17. Refresh Excel VBA Function Results
  18. excel VBA run macro automatically whenever a cell is changed
  19. Code for looping through all excel files in a specified folder, and pulling data from specific cells
  20. VBa conditional delete loop not working
  21. Concatenate column headers if value in rows below is non-blank
  22. Update excel sheet based on outlook mail [closed]
  23. Unicode string literals in VBA
  24. Error13 in Excel VBA in data file
  25. How to extract text within a string of text
  26. How to open a workbook specifying its path
  27. Create folder path if does not exist (saving from VBA)
  28. Access files with long paths (over 260)
  29. Concatenate multiple ranges using vba
  30. How to fix a VBA “type mismatch” error after switching to 64-bit Excel

Leave a Comment