Hi there

I'm having a problem with autofit() when programming excel from vb.net.

My issue is that I have 5 cells merged into one on a single row, with WrapText on, but when I enter a long string of text I only see the first line (and the top pixel or two of the line underneath). I obviously want my merged area to "grow" downwards as it is filled with new text.

I have tried running .. myRange.EntireRow.Autofit() after making the RowHeight very large, but all it does is resize the row back to its original one line height, and not to the bottom line of text.

Perhaps my problem isn't with Autofit() .. but if not, how else to I get a row to "fit" the wrapped text in it ?

Can anyone help ?

Thanks in advance

Andy