Turning of merge warning message
 

Posting this again, hoping for others answers...

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.

Turning of merge warning message
 

I'm not aware of any option to allow you to suppress this message, unless of
course it is part of a VBA routine in which case you can use

Application.DisplayAlerts = False

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"David P." wrote in message
...
Posting this again, hoping for others answers...

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.