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.

Disable alert message when merging cells??
 

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.