Jim Rech wrote a macro called AutoFitMergedCellRowHeight that you may like:
http://groups.google.com/groups?thre...%40tkmsftngp05
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
Samjoy wrote:
How can I get MS Excel to automatically re-size the height of the row when I
wrap text in merged cells?
--
Dave Peterson