/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

0 vote226 views1 answer
Loop through all text boxes in a form vb
VBA
0 vote226 views1 answer
Excel run macro every 5 minutes
VBA
6 votes228 views1 answer
Excel vba isalpha
VBA
0 vote307 views1 answer
Vba array of integers
VBA
1 vote215 views1 answer
Vba optional
VBA
0 vote245 views1 answer
Vbnet convert charatcer to binary
VBA
0 vote176 views1 answer
How to self delete a vbscript file
VBA
0 vote229 views1 answer
Excel vba delete folder
VBA
8 votes282 views1 answer
Excel vba make word
VBA
31 votes277 views1 answer
Excel-vba how to convert a column number into an excel column
VBA