I build a HTML table to go into the_Content variable which is then inserted into a XML document.

The problem I am having is that when the table is built I am getting errors because some of the text content i.e. has got ampersands (&) in it.

I have a function to fix them and replace them with 'AND' but this replaces the escape chars e.g the_Content = the_Content & "<tr>"
the_Content = the_Content & "<td>"
the_Content = the_Content & Trim(Range(sRange).Text)
the_Content = the_Content & "</td>"

How do i stop this?

www.crmpicco.co.uk
www.crmpicco.co.uk.tt
www.milklemonadechocolate.uk.tt
www.griswolds.uk.tt
www.piccosmini.co.uk.tt
www.morton.uk.tt

__________________
_______________________
Ayrshire Minis - a Mini E-Community
http://www.ayrshireminis.com
http://www.crmpicco.co.uk

If Trim(Range(sRange).Text) has & in it Replace '&' with '&'.

so would i just wrap the replace function around the Trim(Range(sRange).Text) ?

www.crmpicco.co.uk
www.crmpicco.co.uk.tt
www.milklemonadechocolate.uk.tt
www.griswolds.uk.tt
www.piccosmini.co.uk.tt
www.morton.uk.tt

for example.....
www.crmpicco.co.uk
www.crmpicco.co.uk.tt
www.milklemonadechocolate.uk.tt
www.griswolds.uk.tt
www.piccosmini.co.uk.tt
www.morton.uk.tt

Yes you should wrap Replace function around Trim(Range(sRange).Text)

that worked

www.crmpicco.co.uk
www.crmpicco.co.uk.tt
www.milklemonadechocolate.uk.tt
www.griswolds.uk.tt
www.piccosmini.co.uk.tt
www.morton.uk.tt