Selection.ColumnWidth

  • Thread starter Thread starter Ron McCormick
  • Start date Start date
R

Ron McCormick

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
 
You state, that the code is the same for all sheets, but are all sheets the same? My guess is you might have merged two columns so that the column width may not be set. I have not tested to see if this error/problem would result by having two merged columns (Or a row that has two merged columns), but just a thought.
 
Back
Top