/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 vote320 views1 answer
Dynamically change drop down list visual basic
VBA
5 votes391 views1 answer
Excel vba low word from Long Integer
VBA
1 vote307 views1 answer
Vba listindex select multiple items vba
VBA
0 vote348 views1 answer
Vba html document reference
VBA
1 vote349 views1 answer
How to INPUT text in shape with enter and spacein vba
VBA
3 votes329 views1 answer
Vba folderexists
VBA
0 vote336 views1 answer
Excel vba cell on change
VBA
0 vote361 views2 answers
Excel vba number format file size
VBA
0 vote356 views1 answer
Excel vba first working day month
VBA
0 vote340 views1 answer
Write listbox to text file vb.net
VBA