Thread: Keep sheet from deleting contents
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Cone Jim Cone is offline
external usenet poster
  
Posts: 3,290
Default Keep sheet from deleting contents

Maybe...
With Worksheets("Parts Sent to Assembly").Range("a3:c100")
.Value = .Value
End With
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"Richard"
wrote in message
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