/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

2 votes187 views1 answer
Excel vba extract file name
VBA
0 vote183 views1 answer
Default host vbox address
VBA
1 vote175 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA
1 vote169 views1 answer
Vba ubound array 2-dimensional
VBA
0 vote176 views1 answer
Openfiledialog specific folder
VBA
0 vote185 views1 answer
Programmatically copy data from one workshet to another excel
VBA
0 vote164 views1 answer
Excel vba populate array with cell values
VBA
0 vote181 views1 answer
Excel delete ever other vba
VBA
0 vote231 views1 answer
Excel vba delete columns in range
VBA
0 vote176 views1 answer
Excel named range sum
VBA