Autofit row height in merged cells

I am producing reports that include comments, some lengthy.
I need several columns for most of the report, so I need
to merge cells for the comments to appear right on the
printed report.
Is there a way to get the row height automatically auto
fit?

I know this works with unmerged cells set alignment to
wrap text and row height to autofit, but once I merge
cells it stops working. Any help?

Also, is there a way make autofit work if the cell is a
formula that points to text?

My apologies to the group. After searching I see someone
else asked this question 11 days ago and was pointed to
the applicable code. Thanks

>-----Original Message-----
>I am producing reports that include comments, some
lengthy.
>I need several columns for most of the report, so I need
>to merge cells for the comments to appear right on the
>printed report.
>Is there a way to get the row height automatically auto
>fit?
>
>I know this works with unmerged cells set alignment to
>wrap text and row height to autofit, but once I merge
>cells it stops working. Any help?
>
>Also, is there a way make autofit work if the cell is a
>formula that points to text?
>.
>