You didn't specify exactly how it fails. Just in case the problem is that
the macro is not shrinking the row height, I should mention it is design
only to increase row heights if needed. The reason being that there could
be other merged cells on the same row that need the greater row height.

Maybe you could copy/paste the problem merged cell into a new workbook and
send it to me, once you verify that the problem reproduces in it of course..

--
Jim Rech
Excel MVP
"kchambers" wrote in message
...
| Yes, I do have wrap text selected.
|
| "Jim Rech" wrote:
|
| There are three requirements and you mentioned 2. Is Wrap Text set for
the
| active cell?
|
| --
| Jim Rech
| Excel MVP
| "kchambers" wrote in message
| ...
| |I have tried to use Jim Rech's macro to autofit a merged cell in excel.
| | However, I cannot seem to get this to work for my situation. I have
(1)
| row
| | merged in (2) columns (D & E.) What am I doing wrong???
|
|
|