/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 vote246 views1 answer
Vba exit while
VBA
-1 vote266 views1 answer
Text to speech vb.net
VBA
0 vote302 views1 answer
Visual basic run command
VBA
0 vote233 views3 answers
Write to text file vb.net
VBA
0 vote232 views1 answer
System.InvalidOperationException: 'Row associated with the currency manager's position cannot be made invisible.
VBA
0 vote243 views1 answer
Worksheet.pastespecial textbox
VBA
0 vote268 views1 answer
How to add line graph vb net
VBA
3 votes256 views1 answer
Vba continue for each loop
VBA
1 vote243 views1 answer
Excel vba get ordinal number from cardinal number
VBA
1 vote224 views1 answer
Excel vba hide zero values
VBA