Move Selection

The Move Selection action moves the current cell selection in a certain direction within a Microsoft Excel workbook.

Note: The Actions Quick Reference provides a complete list of actions that you can print for easy reference.

Creating a Move Selection Action

  1. Drag the Target Selector onto the Targets list in the target workbook to display the available target options.

  2. Continue to drag the Target Selector to the Cell option, expanding the available options.

  3. Select the desired cell option:

    • Current Cell - Performs the action to the active cell in the workbook.
    • Exact Cell - Performs the action to a cell specified by the user. An Exact Cell can also be accessed by targeting it directly.
    • Cell Range - Performs the action to a defined range of cells.
    • Named Range - Performs the action to a named range within the workbook.
  4. If this is the first time the workbook was targeted, Nintex RPA LE will attempt to create a workbook connection automatically. For more information about Microsoft Excel workbook connections, see Excel Connections.

    A preview of the target cell is displayed along with a button that allows you to modify the cell to target, per the selected cell options.

  5. Select the Move Selection action from the Actions list.

  6. Click Rules to change the Connection for this action.

  7. Configure the Timing and Error settings for this action to fine tune the how the action will run.

    Note: For more information about the timing and error settings, go to Action Builder.

  8. Select the horizontal direction and horizontal distance to move the selection.

  9. Select the vertical direction and vertical distance to move the selection.

  10. (Optional) Add Notes to the action to document special instructions or functionality.

  11. Click OK to save the action.

    If the run switch is set to Run, the action will be executed.

    Note: The run switch is set to Run by default. To create or modify this action without executing it, click the slider to change the option to Don't Run.  For more information, go to Action Builder.