Without seeing the code, it is impossible to determine what happened.
However, column width is a function of format and many things affect the
format of cells, columns and rows such as copying from one sheet to another
or from one workbook to another. If you are running SQL, it could have code
that affects format, although rarely so. Your sheet could have had an event
code in it that reset the column width. As I said, there are many things
that could happen after the column width and/or row height is set that might
cause them to change to default or other preset sizes. If you want the best
assistance, post the relevant code so everone can see it.



"Phil Bracken" wrote in message
...
Hi,
I've tried to create a macro that will go in and set the column widths
(columns A thru M) to specific widths. Each column is a different
width. I used the record button and set them as I wanted and then
stopped the recording. When I went to another worksheet in the same
workbook and executed I could see it change the width for a split
second and then they each went to a standard 7.71 width. No error
messages. No explanations.

My goal is a macro to be able to import or copy a page from 5
different worksheets that I receive twice a month and be able to view,
print and extract data from them for other reports.

Thanks in advance,
Phil