Skip to main content

Set Active Cell

Sets the active cell in an Excel file.

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 node.
  • Continue On Error - Automation will continue regardless of any error. The default value is false.
info

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

Input​

  • Excel File Descriptor - Excel file descriptor ID. This ID is generated by the Open Excel or the Create Excel node.
  • Cell - Cell address. (e.g. C3)

Options​

  • Target - Specifies the target cell for setting the active cell. Choose from the following options:
    • Specific Cell - Directly selects the cell specified by its address.
    • Above Cell - Sets the active cell to the one directly above the current active cell.
    • Below Cell - Sets the active cell to the one directly below the current active cell.
    • Next Cell - Moves to the cell immediately to the right of the current active cell.
    • Previous Cell - Moves to the cell immediately to the left of the current active cell.
    • End of the Row - Jumps to the last cell in the current row.
    • Beginning of the Row - Jumps to the first cell in the current row.
    • Next Row - Moves to the cell directly below in the adjacent row, keeping the same column position.

When no target is selected, it defaults to "Next Cell".