Search

Copy & Paste

Last Updated: Feb 14, 2022

Articles

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.

Syntax

Copy & Paste (source_sheet, source_range, destination_sheet, destination_cell, paste_type)

Parameters

Input Parameter Name Description
source_sheet Sheet to copy data from
source_range First cell to last cell value separated by : in the source sheet to copy the data from
destination_sheet Sheet to paste the data to
destination_cell First cell to last cell value 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:
  • value: Numbers and values
  • numberformat: Number format of the value displayed in the Excel
  • cellformat: Cell format (font, colour etc)
  • formula: Formula of the cell

Sample

Copy & Paste (EmployeeSalary, A1:B10, EmployeeDetails, A1:B10, value)

  • Copies the data present in the range A1:B10 from the EmployeeSalary and pastes the value of the copied data to the range A1:B10 in the EmployeeDetails.

To view all the Excel functions, click here.

Did you find what you were looking for?