If you set cell formatting to wrap text, the wrapping will be done
automatically. Does wrapped text affect something else you need to do?

The following works in Excel 2003. When run, it uses the .RowHeight
property to display a dialog box with the height of cell A1. When I
set formatting in A1 to Wrap Text, the height changed when the text was
long enough to cause wrapping.

Dim x As Integer

Sub doathing()
x = Cells(1, 1).RowHeight
MsgBox (x)
End Sub