Peter T -

I'll stand corrected, too.

I was likely using separate column autofits instead of column width pastes.

- Mike


"Peter T" <peter_t@discussions wrote in message
...
"Mike Middleton" wrote in message

As I recall, in Excel 97, I had to use three separate Copy and Paste
commands: one for cell values, one for cell formats, and one for column
widths.

I'll stand corrected but I don't think Excel 97 has any facility to paste
column widths unless an entire sheet is copied to a new sheet. There is of
course PasteSpecial that can paste values or formats and some other
things,
but not row/column dim's.

Regards,
Peter T