/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 vote194 views1 answer
Do until vb.net
VBA
0 vote260 views1 answer
Vba is integer
VBA
1 vote196 views1 answer
Excel vba get ordinal number from cardinal number
VBA
3 votes230 views1 answer
Excel vba get the workbook full filename with path
VBA
0 vote194 views1 answer
Vba add shape oval
VBA
5 votes221 views1 answer
Xlvba double quotes in string literal
VBA
0 vote204 views1 answer
Vbs send keys
VBA
0 vote214 views1 answer
Excel vba textbox forecolor disabled
VBA
1 vote189 views1 answer
Vba compile error object required
VBA
0 vote204 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA