/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 vote236 views1 answer
Excel vba convert cells address
VBA
0 vote202 views1 answer
Loop through each cell in dgv vbnet
VBA
0 vote226 views2 answers
S yyyy-MM-dd em vb net
VBA
0 vote201 views1 answer
Excel vba saveas no prompt for overwrite
VBA
8 votes227 views1 answer
Vba make integer
VBA
0 vote196 views1 answer
Vba round to 2 decimals
VBA
0 vote146 views1 answer
Vba code to remove leading and trailing spaces
VBA
6 votes207 views1 answer
Excel vba check if a string only contains alpha characters
VBA
0 vote210 views1 answer
Vba remove numbers from string
VBA
4 votes202 views1 answer
Excel vba how to get a range's full address including sheet name
VBA