Skip to main content

PasteType

Specifies the part of the range to be pasted.

Type​

Enumeration

Values​

  • "xlPasteAll"
  • "xlPasteAllExceptBorders"
  • "xlPasteColumnWidths"
  • "xlPasteComments"
  • "xlPasteFormats"
  • "xlPasteFormulas"
  • "xlPasteFormulasAndNumberFormats"
  • "xlPasteValues"
  • "xlPasteValuesAndNumberFormats"

Example​

This example paste data with paste all options.

// How to indicate a paste type.

// Specifies the part of the range to be pasted.

// Specifies that all the range will be pasted.

range.PasteSpecial("xlPasteAll");