Disable alert message when merging cells??

When I program to merge some cells in excel, an alert message prompts:

"The selection contains multiple data values. Merging into one cell will
keep the upper-left most data only."

It is somewhat annoying to application users when data is exported to excel
with quite a number of cell merging involved. Is it possible for me to
disable this alert message?

Thanks!

Yung.

Application.DisplayAlerts=False

"yung" wrote:

> When I program to merge some cells in excel, an alert message prompts:
>
> "The selection contains multiple data values. Merging into one cell will
> keep the upper-left most data only."
>
> It is somewhat annoying to application users when data is exported to excel
> with quite a number of cell merging involved. Is it possible for me to
> disable this alert message?
>
> Thanks!
>
> Yung.
>
>
>