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

listi.net

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.