I have been using a routine that inserts rows based on a Form button. It works fine, except:
I included a .RowHeight setting in the routine (which turned out to be unnecessary)
Set insertRow = ws.Cells(rw1, 1).EntireRow
Selection.RowHeight = 14.25 <<=== the problem statement
What this did is remove the AutoFit height for rows, so I have to double-click on the row boundary to "open" the rows (if they overflow the preset height).
I've removed the .RowHeight Statement.
How might I now adjust all the rows to remove the RowHeight constraint?
I know how to loop through all the rows.
Will Selection.Autofit (or something like that) remove the .RowHeight constraint?