/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 vote236 views1 answer
.net crash app
VBA
1 vote213 views1 answer
Excel vba autofit
VBA
0 vote266 views1 answer
(SecurityProtocolType)3072 vb.net
VBA
0 vote202 views1 answer
Quit excel with save changes dialog vb.net
VBA
0 vote224 views1 answer
Vba round to 2 decimals
VBA
3 votes262 views1 answer
Vba post request json
VBA
0 vote252 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
1 vote229 views1 answer
Vba date to unix timestamp
VBA
0 vote235 views1 answer
Excel vba paste all to each sheet in workbook
VBA
1 vote241 views1 answer
Excel vba to lower case
VBA