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
 
Hi Ron

I usually use

Selection.EntireColumn.AutoFit

Does that solve it?

Wolf
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Sheet to Desktop 1
Screen aspect ratios changes when macro runs 2
Auto Column width for new sheets in workbook? 2
macro skips a command 4
Formula SheetName Syntax 3
vba code...... on update........... 3
Workbook Formatting 4
copy sheet complete with command buttons and code into other workbook !!! 6

Back
Top