This documentation is archived and is not being maintained.

XlPasteType Enumeration 

Specifies the part of the range to be pasted.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in

Dim xlPasteType1 As XlPasteType = XlPasteType.xlPasteAll

public enum class XlPasteType
public enum XlPasteType
public enum XlPasteType

Member nameDescription
xlPasteAllEverything will be pasted.
xlPasteAllExceptBordersEverything except borders will be pasted.
xlPasteColumnWidthsThe column width of the source cell will be applied to the destination cell.
xlPasteCommentsComments will be pasted.
xlPasteFormatsFormatting will be pasted.
xlPasteFormulasFormulas will be pasted.
xlPasteFormulasAndNumberFormatsFormulas and number formats are pasted.
xlPasteValidationValidation from the source cell is applied to the destination cell.
xlPasteValuesOnly the values will be pasted.
xlPasteValuesAndNumberFormatsOnly the values number formats will be pasted.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms