COPY

Macro Sheets Only

Equivalent to choosing the Copy command from 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

List of Command-Equivalent Functions