/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

8 votes329 views1 answer
Excel vba determine number of elements in a 2D array
VBA
0 vote257 views1 answer
Vba loop through table
VBA
0 vote286 views1 answer
Vba array dimensions
VBA
1 vote281 views1 answer
Excel vba array remove first
VBA
0 vote293 views1 answer
Iterate all file in a folder vba
VBA
1 vote250 views1 answer
Excel vba hide zero values
VBA
0 vote287 views1 answer
Vba parameter adodb null value
VBA
0 vote301 views1 answer
Make your computer talk vbscript
VBA
0 vote245 views1 answer
Add items to combobox vb.net
VBA
0 vote293 views1 answer
Menus act like radio buttons vb.net
VBA