Copying and Pasting using vB in Excel

  Desert Andy 11:49 08 Mar 2010

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.

  VoG II 11:55 08 Mar 2010


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