Skip to main content

Paste Range

Pastes the copied range from clipboard to a specified location. This node should be used after Copy 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 destination range (e.g., A1). Required when Range is "Specific-Range".
  • To Cell - Ending cell of the destination range (e.g., C10). Required when Range is "Specific-Range".

Output​

This node has no output.

Options​

  • Range - Destination for pasting:
    • Specific-Range - Paste to a specific range (requires From Cell and To Cell)
    • All-Range - Paste starting from the used range

Example​

Pasting to a specific location:

// File Descriptor: message.excel_fd
// From Cell: "F1"
// To Cell: "H5"
// Range: Specific-Range
// Pastes previously copied data to cells F1 through H5

Copy and paste workflow:

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

// 2. Paste Range
// From Cell: "A15"
// To Cell: "D24"
// Range: Specific-Range
// Creates a duplicate of the data 14 rows below

Pasting to another sheet:

// 1. Copy Range from Sheet1

// 2. Activate Sheet2
// Sheet Name: "Destination"

// 3. Paste Range
// From Cell: "A1"
// To Cell: "D10"

Tips​

  • The From Cell and To Cell define the destination range dimensions.
  • Both values and formatting are pasted.
  • If the destination range is smaller than the copied range, only the portion that fits is pasted.
  • If the destination range is larger, the copied data is repeated or the extra cells remain unchanged.
  • Always use Copy Range before Paste Range.

Common Errors​

ErrorSolution
From Cell cannot be empty when Range is Specific-RangeProvide a starting cell address for destination
To Cell cannot be empty when Range is Specific-RangeProvide an ending cell address for destination
Range must be selectedChoose either Specific-Range or All-Range
No data to pasteEnsure Copy Range was executed before Paste Range
Invalid File DescriptorEnsure the Open Excel node was executed first