/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 vote113 views1 answer
Excel format cell as kilowatts
VBA
0 vote116 views1 answer
Vba like with wildcard
VBA
27 votes244 views2 answers
Vba check if file exists
VBA
0 vote134 views2 answers
Checking and changing system volume vb.net
VBA
0 vote118 views1 answer
Compare dates vb
VBA
0 vote111 views1 answer
Quit excel with save changes dialog vb.net
VBA
3 votes140 views1 answer
Extract word in a text in excel
VBA
0 vote117 views1 answer
Vba DisplayGridlines
VBA
0 vote154 views1 answer
Wpf dark title bar
VBA
0 vote128 views1 answer
Sort dictionary by key vba
VBA