/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

8 votes185 views1 answer
Run command pormpt in background windows
VBA
3 votes200 views2 answers
Vba date to string
VBA
1 vote182 views1 answer
Excel vba first row in range
VBA
0 vote157 views1 answer
Get current year vb
VBA
0 vote165 views1 answer
Freeze panes vba
VBA
6 votes178 views1 answer
Excel vba get the path of current workbook
VBA
5 votes186 views1 answer
Vba low byte from INTEGER
VBA
0 vote179 views1 answer
Excel vba paste all to each sheet in workbook
VBA
0 vote155 views1 answer
How to set location and size of new from vb
VBA
2 votes169 views2 answers
Vba code to remove duplicates from a column
VBA