/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 vote188 views1 answer
Add rows to datagridview vb.net
VBA
7 votes174 views1 answer
Excerl vba array to range
VBA
1 vote171 views1 answer
How to check is the value enterd is a number or text in vba
VBA
0 vote182 views1 answer
VBA
VBA
1 vote168 views1 answer
Excel vba Populating a combobox on a userform from a range of cells
VBA
0 vote169 views1 answer
Vbnet check if string is only numbers
VBA
0 vote177 views1 answer
Excel vba select multiple shapes
VBA
3 votes180 views1 answer
Vba make long from two words
VBA
0 vote202 views1 answer
Vbs run with cscript
VBA
0 vote173 views1 answer
Windows Presentation Foundation dark title bar
VBA