XlPasteSpecialOperation Enumeration
Specifies how numeric data will be calculated with the destinations cells in the worksheet.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Public Enumeration XlPasteSpecialOperation
'Usage
Dim instance As XlPasteSpecialOperation
public enum XlPasteSpecialOperation
Members
| Member name | Description | |
|---|---|---|
| xlPasteSpecialOperationAdd | Copied data will be added with the value in the destination cell. | |
| xlPasteSpecialOperationDivide | Copied data will be divided with the value in the destination cell. | |
| xlPasteSpecialOperationMultiply | Copied data will be multiplied with the value in the destination cell. | |
| xlPasteSpecialOperationNone | No calculation will be done in the paste operation. | |
| xlPasteSpecialOperationSubtract | Copied data will be subtracted with the value in the destination cell. |