/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

1 vote449 views1 answer
Excel vba convert text YYYYMMDD to date
VBA
0 vote361 views1 answer
Openfiledialog specific folder
VBA
0 vote406 views1 answer
Application.ExecutablePath VB.NET
VBA
0 vote343 views1 answer
Vb net dgv doesn't keep currency format
VBA
0 vote389 views2 answers
Open url from vba
VBA
0 vote354 views1 answer
Vb check if row has column
VBA
0 vote343 views1 answer
Vb.net visible property dgv collumn not working
VBA
0 vote392 views1 answer
Vba ternary
VBA
4 votes352 views1 answer
Excel vba check cell not empty
VBA
0 vote358 views1 answer
Find the name of the last excel sheet vb
VBA