Automatically adjust column widths

S

stu_padassol

is there a way to write code to automatically adjust column widths so
that when a change is made to the sheet, the column widths will
automatically adjust? I have a pivot table that every time i make a
change, I have to fix the column widths. Any thoughts?
 
S

Stefi

Try this statement:

Cells.EntireColumn.AutoFit
Regards,
Stefi


„stu_padassol†ezt írta:
 
Top