Suppressing dialogs
 

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

Suppressing dialogs
 

Hi Jim,

Does
Application.DisplayAlerts = False
Help at all?

HtH,
JF

On 23 Jan, 12:08, "Jim" wrote:
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

Suppressing dialogs
 

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" wrote:

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

Suppressing dialogs
 

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

"Jim" wrote in message
...
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