How to autofit row height on merged cells with wrapped text

[Bob Lemay]

Autofit works when wraped text cells are not merged.
There doesn't seem to be a way to autofit wrapped cells
when the cells are merged.
One way that I think may work would be to use a macro to
set the row height, but I can't figure out how many lines
the text will occupy in the merged cell.

Any ideas out there?

 

[JE McGimpsey]

If you search the archives:

http://google.com/advanced_group_search?q=group:*excel*

you'll find that one way is to use a macro by Jim Rech:

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