Question : vba double quote
Answered by : vastemonde
Debug.Print """" ' "
Debug.Print Chr(34) ' "
Source : | Last Update : Sun, 31 Jan 21
Question : use " inside strin vba
Answered by : alex-lanaro-14ziv22qcwmq
'Method 1
Worksheets("Sheet1").Range("A1").Formula = "IF(Sheet1!A1=0,"""",Sheet1!A1)"
'Method 2
Worksheets("Sheet1").Range("A1").Formula = "IF(Sheet1!A1=0," & CHR(34) & CHR(34) & ",Sheet1!A1)"
Source : https://stackoverflow.com/questions/9024724/how-do-i-put-double-quotes-in-a-string-in-vba | Last Update : Sat, 21 Nov 20