/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

18 votes171 views2 answers
Vba make word from bytes
VBA
-1 vote147 views1 answer
Code for reading letters only in vb 6
VBA
0 vote118 views1 answer
Vb streamreader
VBA
0 vote73 views1 answer
How to sort datagridview in vb.net
VBA
0 vote86 views1 answer
Excel autofilter vba
VBA
0 vote120 views1 answer
How to make a a msgbpx in vbs
VBA
0 vote116 views1 answer
Vba find sub dictionary
VBA
1 vote121 views1 answer
Excel vba saveas force overwrite
VBA
0 vote129 views1 answer
Vba excel parser xml
VBA
0 vote135 views1 answer
Vba parameter adodb null value
VBA