The Get Active Cell action is used return the position of the active cell or cells in an Excel workbook that is open in an AutoMate Excel session. The action populates one or more variables with the reference points for the cell or cells. An Excel session must be created in an earlier step using the Open Workbook or Create Workbook actions.
Note: You must have Microsoft Excel licensed and installed on your system to use any of the AutoMate Excel actions.
From the Task Builder Available Actions pane, open the Excel folder and double-click the Get Active Cell action or drag it into the Steps pane.
In the Session name box, enter the session name. If your task has only one Excel session and you did not change the default session name when you created it (recommended), you can use the default entry.
In the Get active box, select the cell specification method.
Cell by reference: returns the reference for the cell, such as A1 or B5. If more than one cell is active, the position of the upper left active cell is returned.
Cell by position: returns the row number and column number. This requires two variables, and returns the position of the upper left cell if more than one cell is active.
Range of cells by reference: returns the cell references for the upper left cell and the lower right cell. This requires two variables.
of cells by position: returns the row and column numbers for the
upper left cell and the lower right cell. This requires four variables.
The properties boxes change depending on the selection.
Select the variables in the properties boxes displayed.
To set the Description tab properties, refer to Description Tab Options.
To set the Error Causes and On Error tab properties, refer to Step Error Handling.
When finished, click OK to save settings and close the properties dialog window.
Adding Task Steps
Get Active Cell