AutoFit Method

Applies To

Range object.

Description

Changes the width of the columns in the specified range to achieve the best fit.

Syntax

expression.AutoFit

expression Required. An expression that returns a Range object. Must be a row or a range of rows, or a column or a range of columns. Otherwise, this method causes an error.

Remarks

One unit of column width is equal to the width of one character in the Normal style.

See Also

ColumnWidth property.

Example

This example changes the width of columns A through I on the datasheet to achieve the best fit.

myChart.Application.DataSheet.Columns("A:I").AutoFit

This example changes the width of columns A through E on the datasheet to achieve the best fit, based only on the contents of cells A1:E1.

myChart.Application.DataSheet.Range("A1:E1").Columns.AutoFit