/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

0 vote328 views1 answer
Vba declare 64-bit ptrsafe
VBA
0 vote361 views1 answer
Open file dialog in vb.net
VBA
0 vote339 views1 answer
.net crash app
VBA
1 vote300 views1 answer
Vba listindex select multiple items vba
VBA
1 vote321 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA
1 vote332 views1 answer
Excel format cell as kilowatts
VBA
0 vote347 views1 answer
Vbscript remove spaces from string
VBA
0 vote329 views1 answer
Search in richtextbox vb.net
VBA
3 votes326 views1 answer
Excel vba change format of cell
VBA
4 votes311 views1 answer
Excel vba how to reset usedrange
VBA