One approach to resolve your request is to *avoid* what the message is
warning about, therefore XL doesn't need to display it.

If *only* the top left cell of the merge range contains data, you won't get
the warning message.
Can't you delete any data in the other cells before performing the merge?
You're going to *lose* the data anyway!

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"David P." wrote in message
...
How do I turn off the warning message that says "The selection contains
multiple data values. Merging into one cell will keep the upper-left most
data only." I would like the merge to happen without the warning. Your
help
is appreciated.
--
David P.