Inputing a " within a "
 

Hello,

I know this is simple, but I just can't find it in the HELP files. How do
you insert a " within a "! Here's what I am trying to do:

formatbeg = "<FONT COLOR="336666""

I know how to do it in Perl, but that doesn't work in VBA.
Thanks... Michael Vaughan

Inputing a " within a "
 

Michael

Try

formatbeg = "<FONT COLOR=""336666"""

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Michael Vaughan" wrote in message
...
Hello,

I know this is simple, but I just can't find it in the HELP files. How do
you insert a " within a "! Here's what I am trying to do:

formatbeg = "<FONT COLOR="336666""

I know how to do it in Perl, but that doesn't work in VBA.
Thanks... Michael Vaughan

Inputing a " within a "
 

Double up your quote marks...

formatbeg = "<FONT COLOR=""336666"""

In article ,
"Michael Vaughan" wrote:

Hello,

I know this is simple, but I just can't find it in the HELP files. How do
you insert a " within a "! Here's what I am trying to do:

formatbeg = "<FONT COLOR="336666""

I know how to do it in Perl, but that doesn't work in VBA.
Thanks... Michael Vaughan

Inputing a " within a "
 

Surely I missed that!! ...I need a coffee, ..now!

Absolutely double up the quotes!

Regards,
GS

Inputing a " within a "
 

Got it!!!! Thanks guys.
mv


"Michael Vaughan" wrote in message
...
Hello,

I know this is simple, but I just can't find it in the HELP files. How do
you insert a " within a "! Here's what I am trying to do:

formatbeg = "<FONT COLOR="336666""

I know how to do it in Perl, but that doesn't work in VBA.
Thanks... Michael Vaughan