Copy Paste Range
Last Updated: Dec 1, 2020
Last Updated: Dec 1, 2020
Use this function to copy the content from the given source sheet-range and paste it in the destination sheet-range based on the paste-type given as an input.
Copy Paste Range (source_sheet, source_range, destination_sheet, destination_cell, paste_type)
| Input Parameter Name | Description |
|---|---|
| source_sheet | Sheet to copy data from |
| source_range | Two cell values (first cell and last cell) separated by ‘:’ in the source sheet to copy the data from |
| destination_sheet | Sheet to paste the data to |
| destination_cell | Two cell values (first cell and last cell) separated by ‘:’ in the destination sheet to paste the data to |
| paste_type | The type of information to be pasted. The paste_type could be any of the following:
|
':' is used as separator between the cells.
| Return value | Description |
|---|---|
| Table | Returns the copied data as a table |
Copy Paste Range (Sheet1, A1:B10, Sheet2, A1:B10, value)
To view all the Excel functions, click here.