/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

1 vote192 views1 answer
Excel format cell as kilowatts
VBA
0 vote204 views1 answer
Excel vba delete folder
VBA
0 vote218 views1 answer
Vbnet cycle through charaters in string
VBA
0 vote210 views1 answer
Worksheet.pastespecial textbox
VBA
0 vote186 views1 answer
How to self delete a vbscript file
VBA
0 vote193 views1 answer
Vba copy paste value only
VBA
0 vote220 views1 answer
Filesystemobject vba reference
VBA
8 votes474 views1 answer
Vba make a short integer from two bytes
VBA
0 vote208 views1 answer
Vba string start with
VBA
0 vote191 views1 answer
Vba first cell in range
VBA