/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 vote265 views1 answer
Vba listindex select multiple items vba
VBA
0 vote342 views1 answer
How to call gcd in vba
VBA
2 votes276 views1 answer
Excel vba extract file name
VBA
0 vote286 views1 answer
Vbscript check if string contains
VBA
2 votes276 views1 answer
Vba uppercase first letter of each word
VBA
0 vote293 views1 answer
Vbnet check if string is only numbers
VBA
0 vote292 views1 answer
Excel vba move down to next visible cell
VBA
32 votes434 views2 answers
Excel vba column letter
VBA
0 vote301 views1 answer
Excel vba DisplayAlerts
VBA
4 votes296 views1 answer
Vba create directory
VBA