double quotes in vba strings code example
Example 1: excel formula how to create strings containing double quotes
'The double quotation mark (") is ASCII character 34, so the
'following Excel formula works:
=CHAR(34) & "Excel rocks." & CHAR(34)
'This formula will display: "Excel rocks."
'Using triple double quotes has the same result:
="""Excel rocks."""
Example 2: vba double quote
Debug.Print """" ' "
Debug.Print Chr(34) ' "