By using vba.booksticle.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills

Step 189 - Rows("9:34").EntireRow.AutoFit

This command to part of formatting a spreadsheet.

You can get this code by

Recording a macro

Select rows 9 through 34

Double click the row separator

This will remove excess space in a row or show data that's hidden.