Automatically adjust column widths

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

[Stefi]

Try this statement:

Cells.EntireColumn.AutoFit
Regards,
Stefi


„stu_padassol” ezt �*rta:

>
> 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?
>
>
> --
> stu_padassol
> ------------------------------------------------------------------------
> stu_padassol's Profile: http://www.excelforum.com/member.php...o&userid=36840
> View this thread: http://www.excelforum.com/showthread...hreadid=565469
>
>