PasteSpecial Method

Range object: Pastes data from the Clipboard into the specified range.

Worksheet object: Pastes data from the Clipboard onto the sheet, using a specified format. Use this method to paste data from other applications or to paste data in a specific format.