/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 vote204 views1 answer
Vba format string as cash
VBA
0 vote183 views1 answer
Test if form is open vb
VBA
0 vote183 views1 answer
Vbscript abs
VBA
0 vote223 views1 answer
Vba dictionary clear
VBA
0 vote176 views1 answer
Vba code to open a file with login rights
VBA
0 vote184 views1 answer
Vba run command
VBA
0 vote205 views1 answer
Vba random number
VBA
-1 vote195 views1 answer
Vba sendkeys
VBA
0 vote184 views1 answer
Excel vba calculate
VBA
3 votes200 views1 answer
Excel insert blank row for value change in column
VBA