On Tue, 14 Jul 2009 16:32:55 -0400, Phil Bracken wrote:

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

Sounds strange. Not just that they went back to standard width, but the
standard width you mention is not "Standard". Standard column width in XL,
for as long as I can remember (late 80's) is 8.43 points.

I would redo the macro, and this time, set the column widths for all
sheets, not just the first. See if that helps.

Which still doesn't address the issue of why they went back. ?? Maybe
someone else has run across this glitch.