If I copy a range of cells (either one row, or several rows and colums) from
one work sheet to another the shading, font, data, borders, etc, all copy
over to the new worksheet, but the column widths and row heights do not copy
over. It seems that in older versions of Excel (I'm using Office 2003) I
could use Paste Special|Formats, but this doesn't seem to work in Office
2003. Any suggestions?