/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 vote169 views1 answer
WGET FTP
VBA
0 vote190 views1 answer
Excel vba protect scenarios
VBA
0 vote154 views1 answer
Vba text to general
VBA
1 vote162 views1 answer
Excel vba compare 2 rows
VBA
0 vote167 views1 answer
Vba timestamp -- milliseconds
VBA
0 vote221 views1 answer
Excel vba delete columns in range
VBA
0 vote158 views1 answer
Excel vba center userform
VBA
1 vote177 views1 answer
Export datagridview to excel vb.net
VBA
1 vote177 views1 answer
Add rows to datagridview vb.net
VBA
0 vote182 views1 answer
Excel vba textbox forecolor disabled
VBA