PasteSpecial

PasteSpecial inserts clipboard contents using the specified format into the range area. This method will not paste into cells that lie outside the range. Returns a Boolean. The returned value is 'True', when the process is successful and 'False', when the process fails.

Syntax

object.PasteSpecial( Format, ClipToRange )

Parameter

Type

Required/

Optional

Default

Description

Format

wksClipboard

Required

This specifies the clipboard formats displayed, which may vary depending on where the information was copied from.

ClipToRange

Boolean

Optional

True

This specifies whether the cells lying outside the range should be pasted or not. By default it does not paste cells outside the range.

Example

This example demonstrates how to paste clipboard contents as text only with a range.

WksRange.PasteSpecial(Format:=wksClipboardText, ClipToRange:=True)

Used by: WksRange object