/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 vote246 views1 answer
Vb run command
VBA
0 vote241 views1 answer
Get current url vb.net
VBA
0 vote237 views1 answer
Vba string start with
VBA
0 vote248 views1 answer
Enable macros on opening workbook vba
VBA
6 votes245 views1 answer
Excel vba isalpha
VBA
0 vote258 views1 answer
Vba character ascii code
VBA
0 vote254 views1 answer
Vb ternary
VBA
0 vote249 views1 answer
Dynamic array vba
VBA
0 vote261 views1 answer
Excel delete ever other vba
VBA
0 vote235 views1 answer
Remove first character from string vb
VBA