/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

5 votes242 views1 answer
Vba low word from Long Integer
VBA
0 vote229 views1 answer
Vb check if row has column
VBA
0 vote252 views1 answer
Vba static variable
VBA
0 vote218 views1 answer
Add Formula to Shape Text in VBA
VBA
0 vote255 views1 answer
Pivot data source not accepting table named range vba
VBA
0 vote227 views1 answer
Vb net check if file exists
VBA
0 vote241 views1 answer
Excel vba first working day month
VBA
1 vote235 views1 answer
Random number generator vb.net
VBA
0 vote238 views1 answer
Vba len variant
VBA
1 vote239 views1 answer
Extract the second word in a text in excel
VBA