Ignoring Message

  • Thread starter Thread starter katmando
  • Start date Start date
K

katmando

I've got a macro and part of it is meging cells, but everytime it does
this i get a message that i need to ok.

How can i get the code to "yes" this message on all occasions

Cheers
K
 
Hi Katando,

Try This:


Range("....").Select
Application.DisplayAlerts = False
Selection.Merge
Application.DisplayAlerts = True


This will not show the message at all.


Hoop this helps,



Executor
 
Katmando,

Use the DisplayAlerts property of the Application object. So........

Sub KatmandoMacro()

Application.DisplayAlerts = False
'Your merge code
Application.DisplayAlerts = True

End Sub

Best regards

John
 
Back
Top