WorksheetCopyOptions Properties
Allows you to define copy options when you copy data from one worksheet to another.| Name | Description |
|---|---|
| CopyDefinedNames | Specifies which defined names should be copied in case they contain references to non-existent worksheets. |
| InvalidFormulaReplacementMode | Specifies how to replace copied formulas if they contain references to worksheets that do not exist in the destination workbook. |
| OverwriteProtectionOnLockedWorksheet | Specifies whether to apply cell protection options of the source worksheet to cells in the protected destination worksheet. |
| PasteOptions | Specifies the part of data to paste from the copied worksheet into the target worksheet. |
| SheetMappings | Allows you to specify mappings between worksheet names in the source and destination workbooks. |
See Also