My very basic VBA program dynamically changes rows 5 - 14 with text. Only one column is used. Then I have the program automatically size the rows according to how many lines the rows needs to expand or shrink to:

Rows("5:14").EntireRow.AutoFit
However, I sometimes get problems when running the macro on another machine. It seems like the AutoFit does not know how to properly behave when there are manual carriage returns for some of the rows.

I did a search and most queries with regard to EntireRow.AutoFit discuss changing it based on merged cells. I have no merged cells at all. Again, I think the pattern has to do with the carriage returns.

I also think one solution would be to use the clean() function on the cells to place them in another area, then move them back to their original place. But this SEEMS clumsy.

Please advise. Thank you.

Zachary