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


--
katmando
------------------------------------------------------------------------
katmando's Profile: http://www.excelforum.com/member.php...o&userid=29803
View this thread: http://www.excelforum.com/showthread...hreadid=507616

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

"katmando" wrote in
message ...

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


--
katmando
------------------------------------------------------------------------
katmando's Profile:
http://www.excelforum.com/member.php...o&userid=29803
View this thread: http://www.excelforum.com/showthread...hreadid=507616

Thats what i was looking for

Thanks


--
katmando
------------------------------------------------------------------------
katmando's Profile: http://www.excelforum.com/member.php...o&userid=29803
View this thread: http://www.excelforum.com/showthread...hreadid=507616