## PasteOptions class

Represents the paste special options.

## Constructors

| Name | Description |
| --- | --- |
| [PasteOptions](#constructor) |  |

## Properties

| Name | Type | Description |
| --- | --- | --- |
| [PasteType](#pastetype) | Number | The paste special type. The value of the property is PasteType integer constant. |
| [ShiftFormulasOfShapes](#shiftformulasofshapes) | boolean |  |
| [SkipBlanks](#skipblanks) | boolean | Indicates whether skips blank cells. |
| [KeepOldTables](#keepoldtables) | boolean |  |
| [OnlyVisibleCells](#onlyvisiblecells) | boolean | True means only copying visible cells. |
| [Transpose](#transpose) | boolean | True to transpose rows and columns when the range is pasted. The default value is False. |
| [OperationType](#operationtype) | Number | Gets and sets the operation type when pasting range. The value of the property is PasteOperationType integer constant. |
| [IgnoreLinksToOriginalFile](#ignorelinkstooriginalfile) | boolean | Ingore links to the original file. |

### PasteOptions() {#constructor}

### PasteOptions.PasteType property {#pastetype}

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

**Type:** Number

### PasteOptions.ShiftFormulasOfShapes property {#shiftformulasofshapes}

**Type:** boolean

### PasteOptions.SkipBlanks property {#skipblanks}

Indicates whether skips blank cells.

**Type:** boolean

### PasteOptions.KeepOldTables property {#keepoldtables}

**Type:** boolean

### PasteOptions.OnlyVisibleCells property {#onlyvisiblecells}

True means only copying visible cells.

**Type:** boolean

### PasteOptions.Transpose property {#transpose}

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

**Type:** boolean

### PasteOptions.OperationType property {#operationtype}

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

**Type:** Number

### PasteOptions.IgnoreLinksToOriginalFile property {#ignorelinkstooriginalfile}

Ingore links to the original file.

**Type:** boolean