Was simply addressing a procedure to avoid the warning message David, and
stating the reason for it's absence, *not* advocating its use to not lose
data when merging.

Although, you're correct in stating that caveat, which I should have
probably included.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"David McRitchie" wrote in message
...
That is not documented by Microsoft and you would be using it at your own
risk,
specifically contrary to documentation on addressing merged cells, and if
you
unmerge and then merge again the extraneous data will be lost.
Consider it an anomaly not as something to actually use.

"RagDyer" wrote in message......
Just remembered ... there's a way to merge and *not* lose the data ... so
... makes the warning unnecessary ... so ... XL doesn't display it!