You need to use PasteSpecial Values with the Target Range rather than using Copy with source and destination.

https://docs.microsoft.com/en-us/off...e.pastespecial