Hi Jim,
It's hard to tell where formatting gets lost. You may save html to a file and view in a web browser to see if it's copied from Excel correctly.
>Almost there ... Using your suggestion of "HTML Format" and cdo.HTMLBody gives most curious results ...
>
>(1) I get all the data, appearing in columns (that's the good news)
>
>However,
>
>(2) No colors
>(3) Wrong font size
>(4) No column widths
>(5) No lines between rows/columns
>(6) I get "A" with a little hat on it in places where I would expect CRs (between lines in multiple line column headers).
>
>Ain't that strange?
--sb--