My macro merges various cells (A1 thru K1) at various times. A1 thru E1 are
already merged as one cell but I want to merge them with cells F1:K1. But
when my macro does that, Excel displays this message (and requires that the
User hit "OK"):
"The selection contains multiple data values. Merging into one cell will
keep the upper-left most data only."

I don't want the User to have to hit "OK" every time that the macro merges
the cells (which happens about 20 times) ... how do I tell Excel to
automatically perform the merge without popping-up that message?

Dan

(BTW ... I love this Excel Discussion Group ... you people are SO smart!)