Skip to main content

XlPasteSpecialOperation enumeration

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

Name Value Description
xlPasteSpecialOperationAdd 2 Copied data will be added to the value in the destination cell.
xlPasteSpecialOperationDivide 5 Copied data will divide the value in the destination cell.
xlPasteSpecialOperationMultiply 4 Copied data will multiply the value in the destination cell.
xlPasteSpecialOperationNone -4142 No calculation will be done in the paste operation.
xlPasteSpecialOperationSubtract 3 Copied data will be subtracted from the value in the destination cell.

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>