/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 vote180 views1 answer
Hello world vb.net
VBA
0 vote178 views1 answer
Vbscript Trim
VBA
0 vote173 views1 answer
Remove first character from string vb
VBA
0 vote189 views1 answer
Excel run macro every 5 minutes
VBA
0 vote178 views1 answer
Find days in month vba
VBA
18 votes259 views3 answers
Excel-vba make integer
VBA
0 vote188 views1 answer
Vba remove the first character of string
VBA
0 vote175 views1 answer
Le contrôle SpinButton (Toupie)
VBA
0 vote189 views1 answer
Set column width of datagridview vb.net
VBA
0 vote187 views1 answer
Get current url vb.net
VBA