Automatically adjust column widths

  • Thread starter Thread starter stu_padassol
  • Start date Start date
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?
 
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

column width 3
Column width of Pivot Table data goes back to default when data refreshed 2
Drop Box Width 3
auto fit of column in EXCEL 1
Pivot tables and column widths 1
Column width format 2
Column Width 2
Column/Cell Question 2

Back
Top