/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 vote224 views1 answer
Set column width of datagridview vb.net
VBA
0 vote236 views1 answer
Vbnet round to nearnest thousand
VBA
0 vote311 views1 answer
Vba line feed
VBA
1 vote228 views2 answers
Excel vba password protect
VBA
1 vote215 views1 answer
Highlight selected cell in excel vba
VBA
0 vote228 views1 answer
Excel vba unmerge sheet
VBA
0 vote201 views1 answer
Remove frist letter from string vbnet
VBA
0 vote226 views1 answer
Supprimer la valeur de celule vba
VBA
0 vote232 views1 answer
Add text to Shape VBA
VBA
2 votes210 views1 answer
Vba split string
VBA