/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 vote184 views1 answer
Refer to resource using string variable vb.net
VBA
0 vote177 views1 answer
Vba copy paste value only
VBA
0 vote191 views1 answer
Excel vba urlmon
VBA
1 vote177 views1 answer
Excel vba last column in range
VBA
0 vote195 views1 answer
Vbnet cycle through charaters in string
VBA
1 vote189 views1 answer
Excel vba How to determine if a date falls on the weekend?
VBA
0 vote183 views1 answer
Vbscript abs
VBA
0 vote196 views1 answer
Vba html document reference
VBA
0 vote214 views2 answers
Checking and changing system volume vb.net
VBA
5 votes205 views1 answer
Excel vba right word from Long Integer
VBA