/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 vote180 views1 answer
Vba compare strings
VBA
1 vote181 views1 answer
Excel how to format bytes as KB, MB, GB
VBA
0 vote168 views1 answer
Enter into cells data grid view
VBA
0 vote189 views1 answer
Thread sleep vb
VBA
1 vote195 views1 answer
Find and replace textbox
VBA
0 vote206 views1 answer
Excel vba round to whole number
VBA
1 vote170 views1 answer
Excel vba hide zero values
VBA
1 vote168 views1 answer
Excel vba get ordinal number from cardinal number
VBA
1 vote178 views1 answer
Vba date to unix timestamp
VBA
0 vote179 views1 answer
How to mount floppy disks in vb.net
VBA