/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

1 vote152 views1 answer
How to remove zeros in excel
VBA
0 vote186 views1 answer
Find control with name vb
VBA
1 vote132 views1 answer
Excel vba get ordinal number from cardinal number
VBA
15 votes179 views1 answer
Excel vba wait
VBA
0 vote141 views1 answer
Vba shape transparent
VBA
0 vote139 views1 answer
Excel vba calculate
VBA
0 vote146 views2 answers
Do until loop vba
VBA
0 vote137 views1 answer
Vbnet check if string is only symbols
VBA
5 votes139 views1 answer
Excel formula how to create strings containing double quotes
VBA
1 vote132 views1 answer
VBA Loop through recordset
VBA