/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 vote135 views2 answers
Excel vba number format file size
VBA
1 vote119 views1 answer
Excel vba saveas force overwrite
VBA
0 vote168 views1 answer
How to call gcd in vba
VBA
0 vote127 views1 answer
Vbscript remove spaces from string
VBA
0 vote139 views1 answer
Find database connection string vb
VBA
1 vote137 views1 answer
Excel vba array remove first
VBA
0 vote118 views1 answer
Vbnet add new ecel sheet
VBA
0 vote137 views1 answer
Filesystemobject vba reference
VBA
0 vote125 views1 answer
Test if form is open vb
VBA
0 vote85 views1 answer
Vba set vs dim
VBA