Share via


XlPasteSpecialOperation Enumeration

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

Version Information

Version Added: Excel 2007

Name

Value

Description

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.