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