Range.PasteSpecial Method

Definition

Pastes a Range from the Clipboard into the specified range.

public object PasteSpecial (Microsoft.Office.Interop.Excel.XlPasteType Paste = Microsoft.Office.Interop.Excel.XlPasteType.xlPasteAll, Microsoft.Office.Interop.Excel.XlPasteSpecialOperation Operation = Microsoft.Office.Interop.Excel.XlPasteSpecialOperation.xlPasteSpecialOperationNone, object SkipBlanks, object Transpose);
Public Function PasteSpecial (Optional Paste As XlPasteType = Microsoft.Office.Interop.Excel.XlPasteType.xlPasteAll, Optional Operation As XlPasteSpecialOperation = Microsoft.Office.Interop.Excel.XlPasteSpecialOperation.xlPasteSpecialOperationNone, Optional SkipBlanks As Object, Optional Transpose As Object) As Object

Parameters

Paste
XlPasteType

Optional XlPasteType. The part of the range to be pasted. Can be one of the following XlPasteType constants:xlPasteAll defaultxlPasteAllExceptBordersxlPasteColumnWidthsxlPasteCommentsxlPasteFormatsxlPasteFormulasxlPasteFormulasAndNumberFormatsxlPasteValidationxlPasteValuesxlPasteValuesAndNumberFormats

Operation
XlPasteSpecialOperation

Optional XlPasteSpecialOperation. The paste operation. Can be one of the following XlPasteSpecialOperation constants:xlPasteSpecialOperationAddxlPasteSpecialOperationDividexlPasteSpecialOperationMultiplyxlPasteSpecialOperationNonedefaultxlPasteSpecialOperationSubtract

SkipBlanks
Object

Optional Object. True to not have blank cells in the range on the Clipboard pasted into the destination range. The default value is False.

Transpose
Object

Optional Object. True to transpose rows and columns when the range is pasted. The default value is False.

Returns

Object

Applies to