/VBA/Xlvba double quotes in string literal

Xlvba 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

31 votes459 views1 answer
Vba how to convert a column number into an Excel column
VBA
0 vote331 views1 answer
Build an index all files of a FTP site
VBA
0 vote335 views1 answer
Columns dont autoresize on program start vb.net
VBA
15 votes443 views2 answers
Xl vba dynamic string array
VBA
0 vote311 views1 answer
Vbnet check if number is even or odd
VBA
1 vote299 views1 answer
Excel vba convert cells(1,1) into A1 and vice versa
VBA
2 votes305 views2 answers
Constructor vb.net
VBA
0 vote348 views1 answer
Pivot data source not accepting table named range vba
VBA
27 votes462 views2 answers
Vba check if file exists
VBA
0 vote326 views1 answer
Find control with name vb
VBA