/VBA/Xl vba double quotes in string literal

Xl vba 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 vote243 views1 answer
Windows Presentation Foundation dark title bar
VBA
12 votes291 views1 answer
Excel vba write string to text file
VBA
0 vote252 views1 answer
How to add line graph vb net
VBA
0 vote250 views1 answer
Excel vba DisplayAlerts
VBA
3 votes224 views1 answer
Excel vba last row in range
VBA
0 vote248 views1 answer
Get current year vb
VBA
0 vote240 views1 answer
Get current url vb.net
VBA
0 vote228 views1 answer
Do until vb.net
VBA
0 vote268 views1 answer
Move bindingnavigator vb
VBA
0 vote251 views1 answer
Vba remove last vbcrlf
VBA