PasteType
type PasteType = xlPasteAll | xlPasteAllExceptBorders | xlPasteColumnWidths | xlPasteComments | xlPasteFormats | xlPasteFormulas | xlPasteFormulasAndNumberFormats | xlPasteValues | xlPasteValuesAndNumberFormats
Description
Specifies the part of the range to be pasted.
Try It
oApiRange.PasteSpecial("xlPasteAll");