Copying Data Using the Clipboard
Overview
You can copy unformatted data with tab delimiters from the currently selected cell or block of cells to the Clipboard. Use the standard Clipboard keys to copy data to (Ctrl+C) and paste data from (Ctrl+V) the Clipboard, or use code to accomplish the same operations.
When pasting data from the Clipboard, if a block of cells is selected, the block is replaced with the Clipboard contents. If the contents of the Clipboard are bigger than the selected block, the contents of the Clipboard are truncated at the edge of the block.
If no cells are selected, the contents of the Clipboard are pasted into the sheet starting at the active cell. The contents of the cells to the right of and below the active cell are replaced by the contents of the Clipboard.
By default, column and row headers are included when data is copied and pasted and the pasted headers overwrite the selected headers. You can specify that column and row headers are not included when data is copied and column and row headers are not overwritten when data is pasted.