Thread: Keep sheet from deleting contents
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Richard Richard is offline
external usenet poster
  
Posts: 709
Default Keep sheet from deleting contents
Worksheets("Sent to Assembly").Range("a3:c100").EntireRow.Copy
Destination:=Worksheets("Parts Sent to Assembly").Range("a3:c100")

Is there a way to keep the contents on the "Parts Sent to Assembly" sheet
once the "Sent to Assembly" sheet contents are deleted. Thanks in advance.
Reply With QuoteReply With Quote