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?
 
G

Guest

Try this statement:

Cells.EntireColumn.AutoFit
Regards,
Stefi


„stu_padassol†ezt írta:
 

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

Macro's 1
Pivot Table: Resulting Column Widths on Drill Down 0
adjusting column width using keystrokes 1
Pivot tables and column widths 1
Column widths to adjust automatically? 1
Locking column widths 2
Data display incomplete after creating Pivot Table 6
Varying column widths 1

Top