/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 vote222 views2 answers
Get all column names from excel vba
VBA
0 vote245 views1 answer
Date as number vb
VBA
0 vote260 views1 answer
Vba verticalalignment
VBA
0 vote237 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA
20 votes556 views1 answer
Excel vba factorial
VBA
0 vote266 views1 answer
Excel R1C1 mode
VBA
0 vote277 views1 answer
Excel vba scroll to cell
VBA
0 vote262 views1 answer
Excel vba DisplayAlerts
VBA
7 votes238 views1 answer
Vba array declaration
VBA
0 vote230 views1 answer
Excel vba select multiple shapes
VBA