/VBA/Xlvba double quotes in string literal

Xlvba double quotes in string literal

'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."""

Source: academy.excelhero.com

Similar codes

0 vote124 views1 answer
Vbnet display all axis labels in cahrt
VBA
0 vote142 views1 answer
Rotate image by any angle vb.net
VBA
0 vote157 views1 answer
Vba search string position
VBA
0 vote143 views4 answers
How to continue formula in below line in vba code
VBA
0 vote147 views1 answer
Dlete rows with blanks and space " " vba
VBA
0 vote139 views1 answer
Vba integer to double
VBA
0 vote134 views1 answer
Vba code to select image in sheet
VBA
2 votes141 views1 answer
Vba file from path
VBA
0 vote154 views2 answers
Checking and changing system volume vb.net
VBA
31 votes264 views1 answer
Excel vba function to convert column number to letter
VBA