/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 vote341 views1 answer
Excel vba extract year
VBA
0 vote368 views1 answer
Excel vba clear filter
VBA
0 vote369 views1 answer
Excel last used row
VBA
4 votes343 views2 answers
Vba array length
VBA
0 vote363 views1 answer
Afficher un message d'erreur vba
VBA
0 vote363 views1 answer
Excel vba prevent saving workbook
VBA
1 vote352 views1 answer
S yyyy-MM-dd HH:mm:ss Short Date Local
VBA
2 votes332 views1 answer
Date format for ms chart vb.net
VBA
1 vote311 views1 answer
Ms access open form to new record
VBA
0 vote371 views1 answer
Vba sort the data Z to A
VBA