Skip confirming message

[RaymondR32]

Dear all,

I have created a macro. In some part there is a pop up which says do you want to overwrite the not empty cells ? I always confirm with yes but it interupts the macro which is very anoying. Can excel skip the message and automatic overwrite the not empty cells ?

Thanks in advance.

Raymond

 

[Derek]

Hi Raymond

Try this at the start of your macro

Application.AlertBeforeOverwriting = False

regards
Derek

 

[Legacy 98055]

Hi,

Put this code at the beginning of your macro

Application.DisplayAlerts = False

Put this code at the end of your macro

Application.DisplayAlerts = True

 

[RaymondR32]

Thanks guys, it worked ! You´ve been a great help...

Raymond