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. |