Copy Range

Copies a range of cells to the clipboard for later pasting. This node should be used together with Paste Range.

Common Properties

• Name - The custom name of the node.
• Color - The custom color of the node.
• Delay Before (sec) - Waits in seconds before executing the node.
• Delay After (sec) - Waits in seconds after executing the node.
• Continue On Error - Automation will continue regardless of any error. The default value is false.

info

If ContinueOnError property is true, no error is caught when the project is executed even if the Catch node is used.

Input

• File Descriptor - File descriptor of the Excel file. This is the identifier returned by the Open Excel node.
• From Cell - Starting cell of the range (e.g., A1). Required when Range is "Specific-Range".
• To Cell - Ending cell of the range (e.g., C10). Required when Range is "Specific-Range".

Output

This node has no output.

Options

• Range - Whether to copy all used cells or a specific range:
  • Specific-Range - Copy a specific range (requires From Cell and To Cell)
  • All-Range - Copy all cells with data in the active sheet

Example

Copying a specific range:

// File Descriptor: message.excel_fd
// From Cell: "A1"
// To Cell: "D10"
// Range: Specific-Range
// Copies cells A1 through D10 to clipboard

Copying and pasting to a different location:

// 1. Copy Range
// From Cell: "A1"
// To Cell: "C5"
// Range: Specific-Range

// 2. Paste Range
// From Cell: "F1"
// To Cell: "H5"
// Range: Specific-Range

Copying all data:

// Copy Range
// Range: All-Range
// Copies all used cells

Copying between sheets:

// 1. Activate source sheet
// Sheet Index: 1

// 2. Copy Range
// Range: All-Range

// 3. Activate destination sheet
// Sheet Index: 2

// 4. Paste Range

Tips

• The copied data stays in the clipboard until pasted or until another copy operation.
• This copies both values and formatting (colors, borders, fonts, etc.).
• For copying to a different Excel file or with more control, use Clone Range instead.
• Always follow Copy Range with Paste Range to complete the operation.

Common Errors

Error	Solution
From Cell cannot be empty when Range is Specific-Range	Provide a starting cell address
To Cell cannot be empty when Range is Specific-Range	Provide an ending cell address
Range must be selected	Choose either Specific-Range or All-Range
Invalid File Descriptor	Ensure the Open Excel node was executed first