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

Franketh wrote:

When a group of cells in a row are merged and the text wraps to two or more
lines, double-clicking the row border just to the left of column A (or
Format/Row/Autofit) auto-heights the row to one line of text. Either of
these actions should heighten the row to fit the text in the merged cells.

--

Dave Peterson