/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 vote319 views1 answer
Excel vba extract year
VBA
0 vote329 views1 answer
Refer to resource using string variable vb.net
VBA
0 vote317 views1 answer
How to use VBA to add new record in MS Access?
VBA
0 vote338 views1 answer
Excel vba calculate
VBA
1 vote351 views2 answers
Vba string length
VBA
0 vote362 views1 answer
Vba is integer
VBA
0 vote334 views1 answer
Vba shape transparent
VBA
0 vote325 views1 answer
Telephon call in vba
VBA
0 vote332 views1 answer
String contins in vba
VBA
3 votes341 views1 answer
Vba http request json
VBA