Paste Method [WksRange]

The Paste method inserts the contents of the clipboard into the range area. Cells that lie outside the range do not paste. Returns a Boolean.

Syntax

object.Paste( ClipToRange )

 

Parameter	Type	Description
ClipToRange	Boolean	optional, default=0

 

Example 1

This example demonstrates how to paste all clipboard contents that lie both inside and outside of a range.

WksRange.Paste(False)

Example 2

This example shows how to paste the contents of a single cell across a range of cells.

'Copies the cell B5

Wks.Range("B5").Copy()

 

'Pastes the copied value into all the cells in the new range

Wks.Range("G6:J11").Paste(True)

 

Used by: WksRange object