PasteSpecial Method

The PasteSpecial method inserts clipboard contents into the range area using the specified format. This method will not paste into cells that lie outside the range. Returns a Boolean.

Syntax

object.PasteSpecial( Format, ClipToRange )

 

Parameter	Type	Description
Format	wksClipboard	required, paste format
ClipToRange	Boolean	optional, default=0

 

Example

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

WksRange.PasteSpecial(wksClipboardText,True)

 

Used by: WksRange object