Mon, 12 Nov 2007 21:05:19 -0800 from <Gord Dibben
<gorddibbATshawDOTca:
On Mon, 12 Nov 2007 23:11:08 -0500, Stan Brown
wrote:
I wouldn't call myself an expert -- high intermediate at best. Can
you enlighten me, please? What's wrong with merged cells?
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.
Thanks, Gord.
--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/