Equivalent to clicking the Paste Special command on the Edit menu, and then clicking the Paste Link button in 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
Return to index