跳到主要内容

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 option.

range.PasteSpecial("xlPasteAll");