Thread: Can i use Paste Special in this way?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lost and Looking for Help Lost and Looking for Help is offline
external usenet poster
  
Posts: 15
Default 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")
Reply With QuoteReply With Quote