/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 vote325 views1 answer
Search combobox items vb.net
VBA
0 vote324 views1 answer
For each item in folder outlook vba
VBA
1 vote303 views1 answer
Highlight selected cell in excel vba
VBA
0 vote333 views1 answer
Vba run command
VBA
0 vote325 views1 answer
Vba excel do not recalculate before save
VBA
0 vote296 views1 answer
Putting marquee in vb.net
VBA
5 votes312 views1 answer
Excel vba how to unit test vba code
VBA
1 vote334 views1 answer
How to remove zeros in excel
VBA
0 vote298 views1 answer
Dynamically change drop down list visual basic
VBA
31 votes459 views1 answer
Vba how to convert a column number into an Excel column
VBA