/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

22 votes346 views1 answer
Xl vba check for folder
VBA
0 vote172 views1 answer
Vbscript abs
VBA
1 vote161 views1 answer
Excel vba convert cells(1,1) into A1 and vice versa
VBA
0 vote173 views1 answer
Excel vba clear filter
VBA
0 vote189 views4 answers
Vgrive,deb
VBA
0 vote171 views1 answer
Find days in month vba
VBA
0 vote164 views1 answer
Faire appel à la mise en forme conditionnelle vba excel
VBA
0 vote192 views1 answer
How to make a a msgbpx in vbs
VBA
0 vote192 views2 answers
Checking and changing system volume vb.net
VBA
1 vote167 views1 answer
Excel vba hide zero values
VBA