/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

1 vote318 views1 answer
Excel vba last column in range
VBA
0 vote337 views4 answers
Vgrive,deb
VBA
3 votes326 views1 answer
Vba make long from two words
VBA
3 votes311 views1 answer
Excel vba get the workbook full file name with path
VBA
1 vote312 views1 answer
Excel vba force recalculation
VBA
0 vote321 views1 answer
Vba cell all borders
VBA
5 votes357 views1 answer
Excel-vba get integer high byte
VBA
0 vote311 views1 answer
Vbnet check if string is only numbers
VBA
0 vote303 views1 answer
Vbnet check if number is even or odd
VBA
1 vote296 views1 answer
Highlight selected cell in excel vba
VBA