expression.PasteAndFormat(Type)
expression Required. An expression that returns one of the objects in the Applies To list.
Type Required WdRecoveryType. The type of formatting to use when pasting the selected table cells.
| WdRecoveryType can be one of these WdRecoveryType constants. |
| wdChart Pastes a Microsoft Excel chart as an embedded OLE object. |
| wdChartLinked Pastes an Excel chart and links it to the original Excel spreadsheet. |
| wdChartPicture Pastes an Excel chart as a picture. |
| wdFormatOriginalFormatting Preserves original formatting of the pasted material. |
| wdFormatPlainText Pastes as plain, unformatted text. |
| wdFormatSurroundingFormattingWithEmphasis Matches the formatting of the pasted text to the formatting of surrounding text. |
| wdListCombineWithExistingList Merges a pasted list with neighboring lists. |
| wdListContinueNumbering Continues numbering of a pasted list from the list in the document. |
| wdListRestartNumbering Restarts numbering of a pasted list. |
| wdSingleCellTable Pastes a single cell table as a separate table. |
| wdSingleCellText Pastes a single cell as text. |
| wdTableAppendTable Merges pasted cells into an existing table by inserting the pasted rows between the selected rows. |
| wdTableInsertAsRows Inserts a pasted table as rows between two rows in the target table. |
| wdTableOriginalFormatting Pastes an appended table without merging table styles. |
| wdTableOverwriteCells Pastes table cells and overwrites existing table cells. |
Example
This example pastes a selected Microsoft Excel chart as a picture. This example assumes that the Clipboard contains an Excel chart.
Sub PasteChart()
Selection.PasteAndFormat Type:=wdChartPicture
End Sub