/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 vote143 views1 answer
Excel format cell as kilowatts
VBA
0 vote147 views1 answer
Vba change named range address
VBA
0 vote160 views1 answer
Vba variable number of arguments
VBA
0 vote156 views1 answer
Sort dictionary by key vba
VBA
0 vote174 views1 answer
Excel vba first column in range
VBA
0 vote147 views1 answer
How to use VBA to add new record in MS Access?
VBA
0 vote156 views1 answer
Como ler subitem de um array em json usando vbnet
VBA
0 vote158 views1 answer
Excel vba protect worksheet without password
VBA
0 vote152 views1 answer
Excel vba formatconditions range
VBA
0 vote155 views1 answer
Vba type
VBA