Edit

XlPasteSpecialOperation Enum

  • Reference

Definition

Namespace:
Microsoft.Office.Interop.Excel
Assembly:
Microsoft.Office.Interop.Excel.dll

Specifies how numeric data will be calculated with the destinations cells in the worksheet.

public enum class XlPasteSpecialOperation
public enum XlPasteSpecialOperation
Public Enum XlPasteSpecialOperation
Inheritance
Enum
XlPasteSpecialOperation

Fields

xlPasteSpecialOperationAdd 2

Copied data will be added with the value in the destination cell.
xlPasteSpecialOperationDivide 5

Copied data will be divided with the value in the destination cell.
xlPasteSpecialOperationMultiply 4

Copied data will be multiplied with the value in the destination cell.
xlPasteSpecialOperationNone -4142

No calculation will be done in the paste operation.
xlPasteSpecialOperationSubtract 3

Copied data will be subtracted with the value in the destination cell.

Applies to