/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

4 votes155 views2 answers
Vba array length
VBA
0 vote182 views1 answer
Excel vba move down to next visible cell
VBA
0 vote153 views1 answer
Vbnet hex to binary
VBA
0 vote189 views1 answer
Winforms dark title bar
VBA
31 votes275 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
0 vote114 views1 answer
Vbide vbproject reference
VBA
8 votes178 views1 answer
Excel vba make integer
VBA
0 vote161 views1 answer
Excel vba unmerge sheet
VBA
1 vote148 views1 answer
Excel vba saveas force overwrite
VBA
1 vote158 views1 answer
Excel vba unload userform
VBA