Hi Ron

I usually use

Selection.EntireColumn.AutoFit

Does that solve it?

Wolf
-----Original Message-----
I have a number of sheets on which I need to reset
certain
column widths after updating pivot tables on each of
them. I have a procedure that loops through the sheets,
resetting the column width but on one of the sheets the
Selection.ColumnWidth procedure does not work. I am not
aware of any differences between the sheets. The same
code
is on all sheets and none of them is protected.

Any ideas why this may be happening.

TIA
Ron
.