/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 vote167 views1 answer
Set datetimepicker value to null vb
VBA
0 vote141 views1 answer
Vba clear collection
VBA
0 vote128 views1 answer
Excel vba Column Name to Column Number
VBA
0 vote136 views1 answer
Vba type
VBA
1 vote137 views1 answer
Excel vba array remove first
VBA
0 vote131 views1 answer
Excel vba protect sheet
VBA
5 votes148 views1 answer
Excel-vba get integer high byte
VBA
3 votes136 views1 answer
Excel insert blank row for value change in column
VBA
4 votes123 views1 answer
Excel vba determine number of elements in an array
VBA
0 vote121 views1 answer
Faire appel à la mise en forme conditionnelle vba excel
VBA