Share via

AutoFit Method

  • Article

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   * 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 generates an error.

Example

This example adjusts the selected rows and columns to the best fit.

Sub AutoFitSelection()

   Dim rngSelected

   Set rngSelected = Spreadsheet1.Selection

   rngSelected.Rows.AutoFit
   rngSelected.Columns.AutoFit

End Sub

Applies to | Range Object