Copying

When I try to copy the contents and formatting of one worksheet to another the formatting does not transfer with it? I use the 'paste special' function and select 'all' to copy.

Why?

Jim

None of the formatting? or something specific like Conditional Formatting? What version of Excel are you using?

ChemistB

The column formatting is fine but the row formatting is not transferred? Excel 2003.

It works on one workbook fine but others it doesn't at all.

Jim

Hmmm, if you're speaking of row heights, then I think you are right. Excel offers the opportunity for pasting Column widths but not row heights. Anyone else have a solution?

ChemistB