Auto row hight

[jmhunt1983]

I have a userform that populates some cells on a worksheet. The cells they populate are merged and have wordwrap enabled. The problem is I need to add something to the code that will automatically adjust the row height to fit the contents, however at the moment have had no luck finding a way of doing this. Any ideas?

 

[ZAX]

I have a userform that populates some cells on a worksheet. The cells they populate are merged and have wordwrap enabled. The problem is I need to add something to the code that will automatically adjust the row height to fit the contents, however at the moment have had no luck finding a way of doing this. Any ideas?

Hi jmhunt1983,

Try the following code :

Sub AUTOFIT_ROW_HEIGHT()
    Cells.Select
    Cells.EntireRow.AutoFit
End Sub

ZAX

 

[shg]

Excel won't autofit the row height of merged cells, reason #23 not to merge cells.

If the are merged horizontally (e.g., A1:C1), then the easy way is to use a spare column, say D. Make the width of that column the same width as the combined width of A:C, and use the formula =A1