Suppressing dialogs

[Jim]

I would like to copy and paste to overwite the destination cells without
having the dialog box interupt the process
Please advise on the vba statement to supress the dialog

Regards & TIA

 

[Joshua Fandango]

Hi Jim,

Does
Application.DisplayAlerts = False
Help at all?

HtH,
JF

 

[Mike H]

Jim,

this doesn't display an alert for me, what message are you getting?

Range("A1:a10").Copy Destination:=Range("D2")

you can disable alert messages with

Application.displayalerts=false
'do things
application.displayalerts=true

Mike

 

[Jim]

Mike ... I should have have explained that I wanted to paste values over the
formula ... sorry about that
However Application.DisplayAlerts = False is what I was looking for.
I was using DisplayAlerts=False (without Application.) and it didn't work

Thanks to you all