/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 vote146 views1 answer
Vba sheet visible
VBA
0 vote169 views1 answer
Excel vba round to whole number
VBA
1 vote148 views1 answer
Excel vba get column number from column name
VBA
1 vote158 views1 answer
Vba format string as cash
VBA
1 vote158 views1 answer
Excel date to unix timestamp
VBA
0 vote156 views1 answer
Arq linux
VBA
0 vote144 views1 answer
Add items to combobox vb.net
VBA
0 vote160 views1 answer
Vbnet click on dgv cells
VBA
2 votes104 views2 answers
Vba exit loop
VBA
0 vote183 views1 answer
How to call gcd in vba
VBA