/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 vote343 views1 answer
Telephon call in vba
VBA
0 vote360 views1 answer
Vba loop through textboxes
VBA
0 vote397 views1 answer
Excel vba unlock sheet without password
VBA
0 vote342 views1 answer
Vba text to general
VBA
0 vote356 views1 answer
Vba code to open a file with login rights
VBA
0 vote336 views1 answer
Discern between file and folder given path vb.net
VBA
0 vote360 views1 answer
Vbs exec hidden
VBA
0 vote309 views1 answer
Vba set vs dim
VBA
1 vote356 views2 answers
Vba function return array
VBA
1 vote354 views1 answer
Add rows to datagridview vb.net
VBA