/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 vote197 views1 answer
Excel vba existence of a file
VBA
1 vote237 views2 answers
Vba find last row in range for certain criteria
VBA
0 vote201 views1 answer
Vba loop through textboxes
VBA
0 vote191 views1 answer
Vba apostrophe chr
VBA
0 vote184 views1 answer
Excel vba linter
VBA
0 vote230 views2 answers
Get unique random number in vb.net
VBA
1 vote216 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
0 vote211 views1 answer
String contins in vba
VBA
0 vote212 views1 answer
How to add line graph vb net
VBA
0 vote207 views1 answer
Vbnet make a string to unicode converter
VBA