AutoFit Method
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