Copy Paste Range

Properties

INPUT

Source SheetName: *Specify the “SheetName” from which the range of values needs to be copied, and it accepts value in “String” datatype.

Source Range:  *Specify the range of cells from the source sheet to be copied and it accepts values in “String” datatype.

Destination Sheet:  *Specify the destination sheet name where the range of values to be pasted and it accepts values in “String” datatype.

Destination Cell:  *Specify the “cell” number from the destination sheet to paste the values and it accepts values in “String” datatype.

Options: This parameter allows you to choose what to be read and copied from the range of values. Select the values from the drop-down, 

Value: Allows to copy and paste only the values from the specified range. 
Formula: Allows to copy and paste values along with their formulas from the specified range.
Number Format: Allows to copy and paste the numeric values along with their number formatting, such as currency, percentage, or decimal places.
Cell Format: Allows to copy and paste the cell formatting, including font styles, background colors, borders, and alignment, without copying the actual cell values or formulas.
All: Allows you to copy and paste everything from the specified range, including values, formulas, number formatting, and cell formatting to the destination sheet.

MISC

DisplayName: Displays the name of the activity. The activity name can be customized, which aids in troubleshooting.

SkipOnError: Specify the “Boolean” value as “True” or “False.”
True: Continue executing the workflow regardless of any errors thrown.
False: Halt the workflow if it encounters any errors.
None: If the option is left blank, the activity will, by default, behave as if “False” were chosen.

Version: It indicates the version of the feature being used.

OUTPUT

Result: This parameter allows you to view the execution status of the activity and returns a value in “Boolean.”
True: Indicates that the activity has been executed successfully without any errors.
False: Indicates that the activity has been unsuccessful due to an unexpected error being thrown.

* Represents mandatory fields to execute the workflow.