Turning of merge warning message

G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Turning off merge message 5
column heading, merge, new line. 1
sounds in Excel 2
Merging or "Merging" 1
Merging a vertical column 2
How do I merge two cells without deleting data from the cell? 47
How do I merge cells with multiple data values? 2
Prevent SORT from asking to expand selection in Excel 2007? 4

Top