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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to suppress the prompt from merging cells
Use
Application.displayalerts = false to suppress alerts. Be sure to set back to true as it will remain false after the macro quits. Then alerts like closing a file without saving will not appear. Robert Flanagan Macro Systems Delaware, U.S. 302-234-9857 http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "Shue-Fen KIng" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to suppress the prompt from merging cells
Another approach
Dim rng as Range, vVal as Variant set rng = Range("A1:B9") vVal = rng(1).Value rng.clearContents rng(1).value = vVal rng.merge -- Regards, Tom Ogilvy "Shue-Fen KIng" wrote in message ... 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 |
Reply |
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) |