/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 vote160 views1 answer
Vb net check if file exists
VBA
0 vote176 views1 answer
VBA
VBA
1 vote130 views1 answer
Vba listindex select multiple items vba
VBA
2 votes151 views1 answer
Vba array contains
VBA
0 vote162 views1 answer
Vba leading zeros in string
VBA
0 vote214 views2 answers
Excel vba store array and write to sheet
VBA
0 vote168 views2 answers
Vb.net include quotes in string
VBA
0 vote183 views1 answer
Excel vba named range exists
VBA
1 vote169 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
0 vote173 views1 answer
Create links in msgbox in vb
VBA