Automatically adjust column widths
 

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

Automatically adjust column widths
 

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