Equivalent to clicking the Copy command on the Edit menu. Copies and pastes data or objects.
Syntax
COPY(from_reference, to_reference)
From_reference is a reference to the cell or range of cells you want to copy. If from_reference is omitted, it is assumed to be the current selection.
To_reference is a reference to the cell or range of cells where you want to paste what you have copied.
To_reference should be a single cell or an enlarged multiple of from_reference. For example, if from_reference is a 2 by 4 rectangle, to_reference can be a 4 by 8 rectangle.
To_reference can be omitted so that you can subsequently paste using the PASTE, PASTE.LINK, or PASTE.SPECIAL functions.
Related Functions
CUT Cuts or moves data or objects
PASTE Pastes cut or copied data
PASTE.LINK Pastes copied data or objects and establishes a link to the source of the data or object
PASTE.SPECIAL Pastes specific components of copied data
Return to index