Problem with Wrap text

[srdjan.radnovic]

I have a problem with wrap text in merge cells.

when the cell is formatted (single cells) everiting is OK.

When the merge cells is formatted (three cells in one merge cells) it
is not OK.
I must manually change height of the cells

Please help
Srdjan

 

[GMorris]

I get the same result! It may just be a bug in XL. I
even tried merging the cells AFTER formatting them,
and that didn't make any difference. I also un-merged
the cells, and the word wrap was fine, but on
re-merging them it was just like before. I don't know
if there IS a solution!

 

[Gord Dibben]

Row Autofit will not work with merged cells unless you add event code to
your worksheet.

If you want to go that route...............

See google search thread for code by Greg Wilson. Watch out for word wrap
in the URL which is all one line.

http://groups.google.com/group/micr...60cbeb27874?lnk=st&q=&rnum=4#ca1c160cbeb27874


Gord Dibben MS Excel MVP