| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Retaining formula after deleting contents. | Excel Discussion (Misc queries) | |||
| alert before deleting contents of a cell | Excel Discussion (Misc queries) | |||
| Excel worksheet - Can I make changes in one sheet affect contents of other sheet? | Excel Discussion (Misc queries) | |||
| Deleting contents of cells in non contiguous ranges | Excel Worksheet Functions | |||
| Lookup cell contents in on sheet based on a formula in second sheet | Excel Worksheet Functions | |||
Linear Mode
