Command: paste and format
Pastes the contents of the clipboard into the selected cells and formats them as specified.
paste and format text range Required. An expression that returns the text range of the cells in
which you want to paste the contents of the Clipboard.
type enumeration Required. Specifies the type of formatting to use when pasting the selected
table cells. Can be one of the following:
Pastes a Microsoft Excel chart as an embedded OLE object.
Pastes an Excel chart and links it to the original Excel
Pastes an Excel chart as a picture.
format original formatting
Preserves original formatting of the pasted material.
format plain text
Pastes as plain, unformatted text.
format surrounding formatting
Matches the formatting of the pasted text to the formatting
of surrounding text.
list combine with existing list
Merges a pasted list with neighboring lists.
list continue numbering
Continues numbering of a pasted list from the list in the
list restart numbering
Restarts numbering of a pasted list.
single cell table
Pastes a single cell table as a separate table.
single cell text
Pastes a single cell as text.
table append table
Merges pasted cells into an existing table by inserting the
pasted rows between the selected rows.
table insert as rows
Inserts a pasted table as rows between two rows in the
table original formatting
Pastes an appended table without merging table styles.
table overwrite cells
Pastes table cells and overwrites existing table cells.
This example pastes a selected Excel chart as a picture. This example assumes that the Clipboard
contains an Excel chart.
paste and format (text object of selection) type chart picture