Range.PasteSpecial (Excel)

Pastes a Range object that has been copied into the specified range.

PasteSpecial (Paste, Operation, SkipBlanks, Transpose)

With Worksheets("Sheet1") 
 .Range("C1:C5").Copy 
 .Range("D1:D5").PasteSpecial _ 
  Operation:=xlPasteSpecialOperationAdd 
End With

Arguments

The following arguments are optional

Paste (XlPasteType) - The part of the range to be pasted, such as xlPasteAll or xlPasteValues.

Here you can find possible values for XlPasteType.

Operation (XlPasteSpecialOperation) - The paste operation, such as xlPasteSpecialOperationAdd.

Possible Values are

xlPasteSpecialOperationAdd Copied data will be added to the value in the destination cell.
xlPasteSpecialOperationDivide Copied data will divide the value in the destination cell.
xlPasteSpecialOperationMultiply Copied data will multiply the value in the destination cell.
xlPasteSpecialOperationNone No calculation will be done in the paste operation.
xlPasteSpecialOperationSubtract Copied data will be subtracted from the value in the destination cell.

SkipBlanks (Boolean) - True to have blank cells in the range on the clipboard not be pasted into the destination range. The default value is False.

Transpose (Boolean) - True to transpose rows and columns when the range is pasted. The default value is False.