Best Fit Column Width

jtrevill · Nov 18, 2004

Anyone know how using VB to resize the column width to the best fit?

Thanks for the help!

Norman Jones · Nov 18, 2004

Hi JTrevill

Try something like:

ActiveCell.EntireColumn.AutoFit

Auto column fit	2	Nov 10, 2009
listbox - code to adjust column widths	4	Nov 29, 2009
How to disable column autosizing in Excel 2007	2	Dec 20, 2006
Merged cells width	2	Jun 1, 2005
Column Width	3	May 1, 2010
Autofit column width of all worksheets in active workbook - an example	1	Jun 18, 2004
How to format ListBox columns	3	Mar 28, 2009
Combine two cells without losing data cell formats	2	May 6, 2010

Ask a Question