XlPasteSpecialOperation XlPasteSpecialOperation XlPasteSpecialOperation Enum


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

public enum class XlPasteSpecialOperation
public enum XlPasteSpecialOperation
Public Enum XlPasteSpecialOperation


xlPasteSpecialOperationAdd xlPasteSpecialOperationAdd xlPasteSpecialOperationAdd 2

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

xlPasteSpecialOperationDivide xlPasteSpecialOperationDivide xlPasteSpecialOperationDivide 5

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

xlPasteSpecialOperationMultiply xlPasteSpecialOperationMultiply xlPasteSpecialOperationMultiply 4

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

xlPasteSpecialOperationNone xlPasteSpecialOperationNone xlPasteSpecialOperationNone -4142

No calculation will be done in the paste operation.

xlPasteSpecialOperationSubtract xlPasteSpecialOperationSubtract xlPasteSpecialOperationSubtract 3

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

Applies to