How to autofit row height on merged cells with wrapped text

B

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?
 
Top