/VBA/Xl vba double quotes in string literal

Xl vba 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

1 vote332 views1 answer
Vba listindex select multiple items vba
VBA
0 vote359 views1 answer
Type excel.application is not defined vb
VBA
0 vote350 views1 answer
Vbnet check if number is even or odd
VBA
0 vote480 views1 answer
Wpf dark title bar
VBA
22 votes865 views1 answer
Excelvba check for directory
VBA
0 vote368 views1 answer
Vba createparameter null
VBA
0 vote367 views1 answer
WGET FTP
VBA
0 vote374 views1 answer
Vba round to 2 decimals
VBA
0 vote366 views4 answers
How to continue formula in below line in vba code
VBA
0 vote363 views1 answer
Write listbox to text file vb.net
VBA