Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Changes the width of the columns in the range or the height of the rows in the range to achieve the best fit.
expression.AutoFit
expression A variable that represents a Range object.
Variant
The Range object must be a row or a range of rows, or a column or a range of columns; otherwise, this method generates an error.
One unit of column width is equal to the width of one character in the Normal style.
This example changes the width of columns A through I on Sheet1 to achieve the best fit.
Worksheets("Sheet1").Columns("A:I").AutoFit
This example changes the width of columns A through E on Sheet1 to achieve the best fit, based only on the contents of cells A1:E1.
Worksheets("Sheet1").Range("A1:E1").Columns.AutoFit
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.