I've tried that myself. I used formulae that refer to the active cells of the
merged ranges instead of copying, and used code to force the AutoFit of these
single cells. I format the font colour the same as the cell interior colour
to make it invisible.

There is a problem, however, with the fact that text wrap doesn't act the
same for single cells as it does for merged ranges sized the same. A
correction factor is beneficial but isn't that reliable. So it ends up not
being that elegant. Mine (adapted from Jim Rech's code) has the same problem
in this respect but doesn't require extra real estate. There is the added
complexity of the row insertion and deletion. Six of one and half a dozen of
the other IMHO.

Best regards,
Greg

"abcd" wrote:

I'm using an other way:
I copy the content of the merged-cells in an other unique cell (same
row, out of the printed and viewved area). This other cell is large
enought (same as all the merged cells). This one can fix the
auto-fit-height of the current row, and will make the merged area to be
at the good height.

(sometimes it works better to have the separated cell to have the
value and the merged one to copy from it)