/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 vote216 views1 answer
Find if year is leap year vb
VBA
0 vote211 views1 answer
Excel vba unmerge sheet
VBA
0 vote212 views1 answer
How to add line graph vb net
VBA
0 vote202 views1 answer
Vba file size
VBA
0 vote211 views1 answer
Windows Presentation Foundation dark title bar
VBA
3 votes231 views2 answers
Vba date to string
VBA
1 vote187 views1 answer
Vba Remove Case Sensitivity
VBA
15 votes268 views2 answers
Xl vba dynamic string array
VBA
0 vote206 views1 answer
Hello world vb.net
VBA
0 vote220 views1 answer
Vba static variable
VBA