Paste Special, replace contents of destination

**Cookstein2** · 10-07-2009, 12:02 PM

Hi

I am writting code that copys a range and then pastes the values back over the same range, which gets rid of the functions in the cells. I am doing this for multiple sheets.

When the code pastes the copied selection back over the same range the code is interrupted by a message box that asks me wether I want to replace the contents of the destination cells or not. I do, how do I get my code to answer yes to this message box?

Alex

**royUK** · 10-07-2009, 12:17 PM

Try adding

Application.DisplayAlerts=False
'your code
Application.DispalAlerts=True

**Cookstein2** · 10-08-2009, 04:27 AM

Thanks Roy,

Worked a treat

**royUK** · 10-08-2009, 04:34 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save