Share via


XlPasteSpecialOperation Enumeration

Excel Developer Reference

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.