WorksheetCopyOptions Properties
Allows you to define copy options when you copy data from one worksheet to another.
Name | Description |
---|---|
Invalid |
Specifies how to replace copied formulas if they contain references to worksheets that do not exist in the destination workbook. |
Overwrite |
Specifies whether to apply cell protection options of the source worksheet to cells in the protected destination worksheet. |
Paste |
Specifies the part of data to paste from the copied worksheet into the target worksheet. |
Sheet |
Allows you to specify mappings between worksheet names in the source and destination workbooks. |
See Also