/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 vote161 views1 answer
Excel vba close form escape key
VBA
0 vote171 views1 answer
Default host vbox address
VBA
0 vote167 views1 answer
Excel run macro every 5 minutes
VBA
0 vote200 views1 answer
Vbnet add axis labels to chart
VBA
0 vote158 views1 answer
Vbs
VBA
1 vote159 views1 answer
Vba refresh pivot table
VBA
0 vote162 views1 answer
Refer to resource using string variable vb.net
VBA
2 votes157 views1 answer
Excel vba check if key is in collection
VBA
4 votes160 views2 answers
Vba array length
VBA
0 vote181 views1 answer
Excel vba first column in range
VBA