PasteSpecialOperation
type PasteSpecialOperation = xlPasteSpecialOperationAdd | xlPasteSpecialOperationDivide | xlPasteSpecialOperationMultiply | xlPasteSpecialOperationNone | xlPasteSpecialOperationSubtractDescription
The mathematical operation which will be applied to the copied data.
Try It
oApiRange.PasteSpecial("xlPasteAll", "xlPasteSpecialOperationAdd");