ExcelBanter - Can i use Paste Special in this way?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Can i use Paste Special in this way? (https://www.excelbanter.com/excel-programming/362299-can-i-use-paste-special-way.html)

Lost and Looking for Help

Can i use Paste Special in this way?

Is it possible to use this method to do a paste special. This code is
obviously not correct

Worksheets("Sheet3").Range("A50000:IA50000").Copy
ActiveSheet.Pastespecial (xlpastevalues)
Destination:=Worksheets("Sheet2").Range("B2")

Dave Peterson

Can i use Paste Special in this way?

How about:

Worksheets("Sheet3").Range("A50000:IA50000").Copy
Worksheets("Sheet2").Range("B2").pastespecial paste:=xlpastevalues

Lost and Looking for Help wrote:

Is it possible to use this method to do a paste special. This code is
obviously not correct

Worksheets("Sheet3").Range("A50000:IA50000").Copy
ActiveSheet.Pastespecial (xlpastevalues)
Destination:=Worksheets("Sheet2").Range("B2")

--

Dave Peterson

All times are GMT +1. The time now is 09:05 PM.