/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 vote276 views1 answer
Vba pass named range to function
VBA
0 vote293 views1 answer
Vbscript check if string is empty
VBA
0 vote284 views1 answer
Excel vba center userform
VBA
0 vote283 views1 answer
Vba DisplayGridlines
VBA
0 vote301 views1 answer
Excel VBA web scraping
VBA
11 votes405 views1 answer
Excel vba How to URL encode a string
VBA
0 vote282 views1 answer
Handling a click event anywhere inside a panel vb
VBA
0 vote292 views1 answer
Vbnet make a string to unicode converter
VBA
5 votes301 views1 answer
Xl vba double quotes in string literal
VBA
1 vote289 views1 answer
Excel vba force recalculation
VBA