View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Shue-Fen KIng Shue-Fen KIng is offline
external usenet poster
 
Posts: 1
Default How to suppress the prompt from merging cells

I am writing a macro to merge adjacent cells that have the
same values in the header row. But every merge prompts
the following message:

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

The choice is OK or Cancel.

What is the command to suppress this message and take OK
as default? Thanks.

Regards,
Shue-Fen