/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 vote152 views1 answer
Excel vba center userform
VBA
3 votes164 views1 answer
Vba make long from two shorts
VBA
0 vote161 views1 answer
Freeze panes vba
VBA
0 vote149 views1 answer
Excel vba populate array with cell values
VBA
0 vote210 views2 answers
VB
VBA
0 vote163 views1 answer
Search in richtextbox vb.net
VBA
0 vote168 views1 answer
(SecurityProtocolType)3072 vb.net
VBA
0 vote168 views1 answer
Vba sort multiple columns
VBA
5 votes183 views1 answer
Excel vba get low byte from INTEGER
VBA
0 vote177 views1 answer
Find if year is leap year vb
VBA