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