/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 vote270 views1 answer
Vbnet add axis labels to chart
VBA
1 vote229 views1 answer
Excel vba unload userform
VBA
1 vote237 views1 answer
Export datagridview to excel vb.net
VBA
0 vote219 views2 answers
Excel vba copy paste after last row
VBA
5 votes249 views1 answer
Excel vba get low byte from INTEGER
VBA
0 vote251 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote239 views1 answer
Excel vba open browser
VBA
0 vote234 views1 answer
How to format a textbox as date vb net
VBA
3 votes302 views1 answer
Excel vba make long from two shorts
VBA
0 vote252 views1 answer
Excel vba move down to next visible cell
VBA