View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
gocush[_29_] gocush[_29_] is offline
external usenet poster
 
Posts: 252
Default 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.