Paste Special, replace contents of destination

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