row autofit not working

[soccerlemon]

Excel 97--Okay, I know that row autofit won't work when there are merged cells in a row, and some have suggested that the row autofit doesn't work with various vertical alignment settings. However, I have no merged cells in the row, and I have tried every vertical alignment setting, and still nothing will autofit the row. I checked the exact height and it is still less than the 409 point maximum. So, I am at the end of my rope. I can't figure out what it is that is preventing the autofit row command from functioning. I can resize the row manually, but I shouldn't have to. I would be so happy if anyone can shed some light on this for me.

 

[YossiD]

How do you merge the two rows, without doing it manually in each column? Do you have a macro for that too?

Solution:Step one - add an extra row and merge the twoStep two - create a macro either in a button/label/sheet to instruct through VBARows("145:146").SelectRows("145:146").EntireRow.AutoFitI use this a lot. Came across the solution by chance.It's pain to add the extra row...but I've never come up with anything else.