/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

2 votes82 views2 answers
Vba exit loop
VBA
0 vote122 views1 answer
Vbs send keys
VBA
0 vote130 views1 answer
Vba loop through textboxes
VBA
0 vote119 views1 answer
How to extract a file from an ISO:
VBA
0 vote124 views2 answers
Delete all controls from list of control vb.net
VBA
0 vote115 views1 answer
Vba code for cutoff time
VBA
0 vote141 views1 answer
Vba round to 2 decimals
VBA
0 vote130 views1 answer
Set column width of datagridview vb.net
VBA
5 votes146 views1 answer
Excel vba how to unit test vba code
VBA
0 vote134 views1 answer
Vba keep command window open
VBA