/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 vote147 views1 answer
Limit combobox to list vba
VBA
0 vote148 views1 answer
Vba parameter adodb null value
VBA
0 vote146 views1 answer
Returns an array from function vba
VBA
1 vote143 views1 answer
Excel vba Populating a combobox on a userform from a range of cells
VBA
0 vote159 views1 answer
Write listbox to text file vb.net
VBA
0 vote149 views1 answer
Vbscript remove spaces from string
VBA
8 votes227 views1 answer
Excel vba determine number of elements in a 2D array
VBA
0 vote153 views1 answer
Excel vba copy entire sheet paste values
VBA
3 votes143 views1 answer
Vba folderexists
VBA
3 votes156 views1 answer
Vba make long from two words
VBA