/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 vote121 views1 answer
How to use if condition in time vba
VBA
0 vote123 views1 answer
How to carry text to the next line in a label in vb.net
VBA
0 vote109 views1 answer
Vba argument is set
VBA
0 vote126 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
0 vote126 views1 answer
Putting marquee in vb.net
VBA
0 vote128 views1 answer
Vba horizontalalignment
VBA
0 vote126 views1 answer
Delete rows in excel vba code
VBA
0 vote119 views1 answer
Vbnet access System.InvalidOperationException: 'Update requires a valid UpdateCommand when passed DataRow collection with modified rows.'
VBA
0 vote129 views1 answer
Vbscript Trim
VBA
1 vote113 views1 answer
Excel format cell as kilowatts
VBA