Turning of merge warning message

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
Merging or "Merging" 1
column heading, merge, new line. 1
Maximum Row Height Greater than 409.5 4
Merging a vertical column 2
sounds in Excel 2
How do I merge two cells without deleting data from the cell? 47
Count with merged cells 2

Back
Top