Copying and Pasting using vB in Excel

  Desert Andy 11:49 08 Mar 10
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 10

Try


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

  Desert Andy 12:05 08 Mar 10

Thank you

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

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

How VR is being used to simulate space

New iPad, iPhone SE & Red iPhone 7 on sale now