/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 vote243 views1 answer
Vba add shape oval
VBA
0 vote280 views1 answer
How to call gcd in vba
VBA
1 vote264 views1 answer
Excel vba get column number from column name
VBA
0 vote241 views1 answer
Find if year is leap year vb
VBA
2 votes230 views1 answer
Vba round number
VBA
0 vote176 views1 answer
Vba code to remove leading and trailing spaces
VBA
0 vote247 views1 answer
Excel vba textbox forecolor disabled
VBA
8 votes247 views1 answer
Excel vba make integer
VBA
15 votes280 views1 answer
Excel vba wait
VBA
0 vote226 views1 answer
Vba file size
VBA