/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 vote278 views1 answer
Vbnet get file name from path
VBA
0 vote285 views1 answer
How to use if condition in time vba
VBA
3 votes293 views2 answers
Vba active workbook path
VBA
0 vote289 views1 answer
Do while not vb.net
VBA
4 votes283 views1 answer
Excel vba how to get a range's full address including sheet name
VBA
0 vote306 views1 answer
Vba keep command window open
VBA
1 vote283 views1 answer
Add rows to datagridview vb.net
VBA
0 vote287 views1 answer
Vbnet check if string is only numbers
VBA
-1 vote270 views1 answer
Text to speech vb.net
VBA
-1 vote292 views1 answer
Vba code to add new column in table
VBA