Copy Paste Range
Copy and paste the range of excel sheet.
Copies an entire range of excel sheet and paste it to a specified excel sheet.
Input
Input :
ExcelHandle Argument
A variable name that references the opened excel file handle.
Sheet Name :
String Argument
The name of the sheet in which the range to be copied.
Source Range :
String Argument
The range of the excel sheet in which the value is to be copied.
Options
Destination File Path :
String Argument
The File Path in which the range to be pasted. IF you want to modify the same input file, the destination path not required.Destination Sheet :
String Argument
The name of the sheet in which the range to be pasted.
Destination Cell :
String Argument
The name of the starting cell in which the range to be pasted.
Copy Method : The method that is used to copy paste the range of excel.
CellContent
- copy paste the formula of the specified range.CellValue
- copy paste the value of the cell or value produced by the formula.
Last updated