Export (0) Print
Expand All
Expand Minimize

XlPasteType Enumeration 

Specifies the part of the range to be pasted.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)

'Usage
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

Community Additions

ADD
Show:
© 2014 Microsoft