Equivalent to clicking the Paste command on the Edit menu. Pastes a selection or object that you copied or cut using the COPY or CUT function. Use PASTE when you want to paste all components of the selection. To paste only specific components of the selection, use PASTE.SPECIAL.
Syntax
PASTE(to_reference)
To_reference is a reference to the cell or range of cells where you want to paste what you have copied. If to_reference is omitted, Microsoft Excel pastes to the current selection. If there is nothing to paste, the macro halts.
Related Functions
COPY Copies and pastes data or objects
CUT Cuts or moves data or objects
FORMULA Enters values into a cell or range or onto a chart
INSERT Inserts cells
PASTE.LINK Pastes copied data and establishes a link to its source
PASTE.SPECIAL Pastes specific components of copied data
Return to index