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

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?