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

Samsung Galaxy S9 review

Artist Helen Friel on designing paper models for everyone to make

What to expect at Apple's 27 March education event

Idées cadeaux pour geeks et tech addicts