XlPasteSpecialOperation Enumeration (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

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.

Show: