/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 vote178 views1 answer
Excel vba StartUpPosition
VBA
0 vote179 views1 answer
Excel vba unmerge sheet
VBA
0 vote220 views1 answer
Excel vba delete columns in range
VBA
1 vote215 views1 answer
Perform http request in vb.net
VBA
0 vote177 views1 answer
Vba collection contains
VBA
1 vote173 views1 answer
Excel vba last column in range
VBA
0 vote169 views1 answer
Vbnet check if string is only numbers
VBA
0 vote150 views1 answer
Excel autofilter vba
VBA
0 vote168 views1 answer
Vba type variable
VBA
5 votes197 views1 answer
Excel vba first byte from INTEGER
VBA