Getting row height to change to match word wrap
 

I have a row which I have set WrapText to True. The row has formulas
returning strings of different length. But the row height is not dynamic,
in that it will not increase in height if the string becomes longer. I can
easily fire off a macro every time the string length changes, but I can't
find what to do to get the height to change. Turning off and on WrapText
doesn't work. Calculating that row doesn't work. (It is already on auto
calc.) What will work?

Don <www.donwiss.com (e-mail link at home page bottom).