/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

5 votes254 views1 answer
Excel vba left word from Long Integer
VBA
12 votes502 views1 answer
Excel vba write string to text file
VBA
0 vote221 views1 answer
How to use VBA to add new record in MS Access?
VBA
1 vote215 views2 answers
Vba string to date
VBA
5 votes171 views1 answer
Vlookup vba
VBA
0 vote239 views4 answers
Vgrive,deb
VBA
4 votes217 views1 answer
Excel formula for last non-empty cell in a column
VBA
0 vote253 views1 answer
Vba code to select image in sheet
VBA
2 votes235 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
3 votes222 views1 answer
Excel vba get the workbook full file name with path
VBA