/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

0 vote318 views2 answers
Excel vba copy paste after last row
VBA
0 vote317 views1 answer
Excel VBA web scraping
VBA
1 vote278 views1 answer
Vba Remove Case Sensitivity
VBA
0 vote297 views1 answer
Vba exit while
VBA
4 votes314 views1 answer
Vba create directory
VBA
0 vote291 views1 answer
Dynamically change drop down list visual basic
VBA
0 vote333 views1 answer
Excel vba protect shapes
VBA
0 vote315 views1 answer
Vba sheet hide unhide
VBA
0 vote380 views2 answers
Excel vba store array and write to sheet
VBA
0 vote322 views1 answer
Vba remove last vbcrlf
VBA