/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 vote192 views1 answer
Vba file chooser
VBA
25 votes262 views3 answers
String to date vb
VBA
1 vote192 views1 answer
Excel how to format bytes as KB, MB, GB
VBA
0 vote194 views1 answer
Excel vba urlmon
VBA
0 vote188 views1 answer
Vba find last column in a row with data
VBA
1 vote191 views1 answer
Vba date to unix timestamp
VBA
0 vote182 views1 answer
VBA is form loaded
VBA
0 vote168 views1 answer
Quit excel with save changes dialog vb.net
VBA
0 vote191 views1 answer
Power query M substract minimum value of column -dax
VBA
0 vote245 views1 answer
Vba vbcrlf chr
VBA