Thread: Not using select for copy and paste
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
damorrison damorrison is offline
external usenet poster
  
Posts: 91
Default Not using select for copy and paste
Hi,

How could I use this code without the select??

Sheets("Recovered_Sheet1").Select
Range("A10").Select
Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Copy
Sheets("New Format").Select
Range("A2").Select
ActiveSheet.Paste
Application.CutCopyMode = False

Reply With QuoteReply With Quote