/VBA/Xlvba double quotes in string literal

Xlvba 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 vote156 views1 answer
Vba is integer
VBA
8 votes232 views1 answer
Excel vba determine number of elements in a 2D array
VBA
0 vote149 views1 answer
Hello world vb.net
VBA
6 votes174 views1 answer
Excel vba isalpha
VBA
0 vote158 views1 answer
Create links in msgbox in vb
VBA
0 vote159 views1 answer
Remove series name from legendvbnet
VBA
0 vote159 views1 answer
Vba sort multiple columns
VBA
5 votes169 views1 answer
Excel vba tool to help with refactoring code
VBA
1 vote153 views1 answer
Excel vba first and last row and column in range
VBA
1 vote152 views1 answer
Excel vba to lower case
VBA