Auto-Fit Rows

You can use this code to auto-fit all the rows in a worksheet.

When you run this code it will select all the cells in your worksheet and instantly auto-fit all the row.

Sub AutoFitRows

Cells.Select

Cells.EntireRow.AutoFit

End Sub