/VBA/Xl vba double quotes in string literal

Xl vba 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

31 votes246 views1 answer
Vba how to convert a column number into an Excel column
VBA
0 vote128 views1 answer
Move bindingnavigator vb
VBA
0 vote115 views1 answer
Vba check 32 or 64 bit
VBA
1 vote137 views2 answers
Excel vba password protect
VBA
0 vote126 views1 answer
Vba code to open a file with login rights
VBA
31 votes250 views1 answer
Excel vba function to convert column number to letter
VBA
8 votes238 views1 answer
Vba convert 2 bytes to an integer
VBA
0 vote142 views1 answer
Excel vba set cell value to empty
VBA
0 vote113 views1 answer
Excel vba milliseconds
VBA
-1 vote117 views1 answer
Vba sendkeys
VBA