/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 vote162 views1 answer
How to INPUT text in shape with enter and spacein vba
VBA
-1 vote150 views1 answer
For i in range vba
VBA
0 vote159 views1 answer
Search in richtextbox vb.net
VBA
0 vote144 views1 answer
Faire appel à la mise en forme conditionnelle vba excel
VBA
0 vote162 views1 answer
Excel vba automatic calculation
VBA
0 vote156 views1 answer
Excel vba Column Name to Column Number
VBA
1 vote170 views1 answer
How to remove zeros in excel
VBA
0 vote151 views1 answer
Excel vba disable copy paste
VBA
5 votes173 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA
5 votes179 views1 answer
Excel vba get low byte from INTEGER
VBA