new PasteOptions()

Methods

getOnlyVisibleCells()

True means only copying visible cells.

getOperationType()

Gets and sets the operation type when pasting range. The value of the property is PasteOperationType integer constant.

getPasteType()

The paste special type. The value of the property is PasteType integer constant.

getSkipBlanks()

Indicates whether skips blank cells.

getTranspose()

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

setOnlyVisibleCells()

True means only copying visible cells.

setOperationType()

Gets and sets the operation type when pasting range. The value of the property is PasteOperationType integer constant.

setPasteType()

The paste special type. The value of the property is PasteType integer constant.

setSkipBlanks()

Indicates whether skips blank cells.

setTranspose()

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