Merged cells cause no end of problems with sorting, copying, pasting, filtering
and a host of other functions, one of which is you can't use array formulas on a
range with merged cells.

To experiment, merge a few cells and try the above functions with a range that
has merged and unmerged cells.


Gord Dibben MS Excel MVP

On Mon, 12 Nov 2007 23:11:08 -0500, Stan Brown
wrote:

Mon, 12 Nov 2007 08:11:22 -0000 from <"David Biddulph" <groups [at]
biddulph.org.uk:
Many experts on this group would recommend avoiding merged cells like the
plague.

I wouldn't call myself an expert -- high intermediate at best. Can
you enlighten me, please? What's wrong with merged cells?