/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 vote220 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA
0 vote268 views1 answer
Excel vba protect sheet
VBA
0 vote221 views1 answer
Excel vba assign shortcut key to button
VBA
0 vote227 views1 answer
Change form background image vb
VBA
0 vote211 views1 answer
Vbnet line graph smooth lines
VBA
3 votes233 views1 answer
Vba double quote
VBA
2 votes171 views1 answer
Excel vba pause
VBA
0 vote257 views1 answer
Set datetimepicker value to null vb
VBA
0 vote202 views1 answer
Vba code to open a file with login rights
VBA
0 vote297 views1 answer
Excel vba add reference programmatically
VBA