Range.PasteSpecial Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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 ObjectParameters
- 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.