Copy Destination - Values only

[CookieMonster76]

Hi

Can I convert this so that instead of copying the formula it just copies the values?

With Range("A:A")
Copy Destination:=Sheets("Sheet1").Range("B:B")"

Thanks

Paul

 

[Fishboy]

Hi

Can I convert this so that instead of copying the formula it just copies the values?

With Range("A:A")
Copy Destination:=Sheets("Sheet1").Range("B:B")"

Thanks

Paul

Hi Paul,

You can't use the Copy / Destination method with PasteSpecial. You will need to split that single line of code into 2 lines like this:

With Range("A:A")
.Copy
Sheets("Sheet1").Range("B:B")".PasteSpecial xlPasteValues