Disable alert message when merging cells

Question

Hello team,&nbsp;I'm developing macro to generate separate copy from master template.within master template I have multiple worksheets and within worksheet few cells are merged.when I create copy from master template due to merge cell, I'm getting pop up alert.&nbsp;"Merging&nbsp;cells only keeps the upper-left value and discards other values."&nbsp;Is there any way I can turn this alert off while creating a copy?

sunnyalv17 · Answer

Sumit_Bhokare&nbsp;Application.DisplayAlert = False

dadosljeme · Answer

Hello&nbsp;Sumit_Bhokare&nbsp;this throws an error:&nbsp;

djclements · Answer

DadoSljeme&nbsp;That's Application.DisplayAlerts&nbsp;(with an s). Caution should be taken when disabling alerts... it's highly recommended to use error handling of some sort in order to make sure alerts are always turned back on. For example:&nbsp;    On Error Resume Next
    Application.DisplayAlerts = False
        'your code here...
    Application.DisplayAlerts = True
    If Err.Number &lt;&gt; 0 Then
        MsgBox Err.Description, vbExclamation, "Runtime Error: " &amp; Err.Number
        Err.Clear
    End If
    On Error GoTo 0

dadosljeme · Answer

Many thanks djclements of course Application.DisplayAlerts&nbsp;. I limit exactly only the area of the code, where I know there are Alerts that would block the flow but are safe to be turned off. Unfortunately Excel VBA does not offer to suppress them in the function itself, for example in the .merge method.

Forum Discussion

Disable alert message when merging cells

Share

Resources