跳到主要内容

PasteType

指定要粘贴的区域部分。

类型

枚举

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

示例

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");