Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How suppress chart points - cells with formulae returning null | Charts and Charting in Excel | |||
Suppress Update Links Prompt | Excel Discussion (Misc queries) | |||
Pivot Table -- Suppress blank cells | Excel Discussion (Misc queries) | |||
suppress duplicate leading cells | Excel Discussion (Misc queries) | |||
Can I suppress the text in Excel an just print the cells I want t | Excel Discussion (Misc queries) |