Text wrap in a cell

[Ernie]

I was able to create a fix by forcing a hard return
(alt+enter)at the point where the text normally would have
wrapped. It seems to me there should be better fix.

 

[Gord Dibben]

Ernie

Wrap text works on merged cells. Autoheight does not. Perhaps this is what
you experiencing. You can resize manually or via Macro. Jim Rech has written
code for this.

http://groups.google.com/groups?threadm=e1$1uzL1BHA.1784@tkmsftngp05

Note also a recent adaptation of this code by Greg Wilson.

http://makeashorterlink.com/?P37D24B15

Gord Dibben Excel MVP XL2002