PASTE.LINK

Macro Sheets Only

Equivalent to choosing the Paste Special command from the Edit menu, and then choosing the Paste Link option from the Paste Special dialog box. Pastes copied data or objects and establishes a link to the source of the data or object. The source can be either another Microsoft Excel workbook or another application. Use PASTE.LINK when you want Microsoft Excel to automatically update the paste area with any changes that occur in the source.

Syntax

PASTE.LINK( )

Note To work properly, the application you are linking to must support dynamic data exchange (DDE) or object linking and embedding (OLE).

Related Functions

COPY Copies and pastes data or objects

CUT Cuts or moves data or objects

PASTE Pastes cut or copied data

PASTE.SPECIAL Pastes specific components of copied data

List of Command-Equivalent Functions