Excel 97: Copy Range with all formatting to another Sheet
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
|