/VBA/Xl vba double quotes in string literal

Xl vba 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 vote121 views1 answer
Putting marquee in vb.net
VBA
5 votes137 views1 answer
Excel vba second byte from INTEGER
VBA
4 votes137 views1 answer
Excel vba how to programmatically remove the marching ants after range copy
VBA
8 votes97 views1 answer
Excel vba make a short integer from two bytes
VBA
0 vote128 views1 answer
Vbs
VBA
0 vote118 views1 answer
Refresh token em vb net
VBA
5 votes129 views1 answer
Excel vba left word from Long Integer
VBA
0 vote128 views1 answer
Excel vba linter
VBA
1 vote116 views1 answer
Excel vba compare 2 rows
VBA
0 vote129 views1 answer
Group controls programmatically vb
VBA