/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

1 vote180 views1 answer
Excel date to unix timestamp
VBA
0 vote173 views1 answer
Excel R1C1 mode
VBA
1 vote171 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA
0 vote177 views1 answer
VBA Loop to range
VBA
0 vote152 views1 answer
Vba argument is set
VBA
0 vote171 views1 answer
Refer to resource using string variable vb.net
VBA
32 votes315 views2 answers
Excel vba column letter
VBA
4 votes168 views1 answer
Vba create directory
VBA
0 vote179 views4 answers
Jwt token vb.net validation
VBA
0 vote188 views1 answer
If statement vdhl
VBA