CopyOptions Properties

The CopyOptions type exposes the following members.

Properties
  NameDescription
Public propertyColumnCharacterWidth
Indicates whether copying column width in unit of characters.
Public propertyCopyInvalidFormulasAsValues
If the formula is not valid for the dest destination, only copy values.
Public propertyCopyNames
Indicates whether copying the names.
Public propertyExtendToAdjacentRange
Indicates whether extend ranges when copying the range to adjacent range.
Public propertyKeepMacros
Indicates whether keeping macros;
Public propertyReferToDestinationSheet
When copying the range in the same file and the chart refers to the source sheet, False means the copied chart's data source will not be changed. True means the copied chart's data source refers to the destination sheet.
Public propertyReferToSheetWithSameName
When copying a worksheet to another workbook and the worksheet contains the formulas which refer to other worksheets in MS Excel, the copied formulas should refer to source workbook. But sometimes we have copied other worksheets and we hope the copied formulas refer to other worksheets with the name in the same workbook, please set this property as true.
See Also