/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 vote353 views2 answers
Get all column names from excel vba
VBA
0 vote360 views1 answer
Vbnet convert charatcer to binary
VBA
-1 vote351 views1 answer
Vba code to add new column in table
VBA
0 vote318 views1 answer
Vb net show lines for all axis labels in chart
VBA
0 vote352 views1 answer
Vba run command
VBA
0 vote343 views1 answer
Excel vba hide gridlines
VBA
1 vote325 views1 answer
How to do error handling in access vba
VBA
5 votes369 views1 answer
Vba low word from Long Integer
VBA
0 vote343 views1 answer
Excel vba chrw max value
VBA
0 vote339 views2 answers
Get excel file from email attachment in vba
VBA