Jim,

THanks for pointing out the 2002 xlPasteColumnWidths. No wonder I
couldn't get xlColumnWidths to work!

Yes, that is good enough.

Ta,

Mark


"Jim Rech" wrote in message ...
The constant is xlPasteColumnWidths in Excel 2002 and 2003. This doesn't
work in 2000 as you know so since "8" works in all versions (post Excel 97)
that may be the way to go.

There is no xlPasteRowHeights unfortunately. The workarounds are (1)
copy/paste entire rows. When an entire row is copied the row height comes
along. (2) A macro that adjusts each destination row to match its
corresponding source row height. Good enough?