Turning of merge warning message

D

David P.

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.
 
K

Ken Wright

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 :)
------------------------------­------------------------------­----------------
 
Top