Help files

Select Cells in Excel Worksheet Action
Description:

This Action selects a range of cells in the active worksheet of a previously launched Excel Instance.

selectcellsinexcelworksheetaction.png
selectcellsinexcelworksheetaction2.png
Properties:

Excel Instance:

Enter the Variable that contains the Excel Instance you want to work with.

Select:

Choose whether to select an explicitly specified range of cells or a range of cells relative to the currently active cell.

Range Start at Column:

Enter a numeric value or letter to be the first column.

Range Starts at Row:

Enter a numeric value to be the first row number.

Range Ends at Column:

Enter a numeric value or letter to be the last column.

Range Ends at Row:

Enter a numeric value or letter to be the last row. The numbering starts at 1.

Range Ends at X Axis direction:

Select the X-axis offset direction. Select where to look along the horizontal axis, based on the currently activated cell's position.

Number of Cells:

Enter a numeric value to be the X-axis offset.

Range Ends at Y Axis direction:

Select the Y-axis offset direction. Select where to look along the vertical axis, based on the currently activated cell's position.

Number of Cells:

Enter a numeric value to be the Y-axis offset.