How can you copy the column width from one workbook to another workbook? When I select a range of information in a sheet in one workbook and try to use the paste or paste special, the width of the original columns are not retained. I must then reformat the new worksheet. I am working in Excel 97. I do not see where Styles allow for any kind of column setting. Would a macro have to be written to take care of this? Does Excel 2000 take care of this problem?
