Copying and Pasting using vB in Excel

  Desert Andy 11:49 08 Mar 2010
Locked

I a copying and pasting a number of cells from one workbook into another. I get the message "Do you want to replace the contents of the destination cells." Can I do something so that this message does not appear to thew user.
Thanks

  VoG II 11:55 08 Mar 2010

Try


Application.DisplayAlerts = False
'
'code for pate
'
Application.DisplayAlerts = True

  Desert Andy 12:05 08 Mar 2010

Thank you

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Intel Coffee Lake release date and specifications

12 Amazing British Craft Beer Label Designs

watchOS 4 review

Les meilleurs navigateurs internet 2017