Help files

Get First Free Column/Row Action

Description:

This Action retrieves the first free column and/or row of the active worksheet. This is useful for adding new data into a worksheet that already has data in it.

Get_First_Free_Column-Row.png
Properties:

Excel Instance:

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

Store First Free Column into:

Enter the name of the Variable that will store the numeric value of the first fully empty column. This will be a number. For example, if column F is the first empty column, it will be stored as '6'.

Store First Free Row into:

Enter the name of the Variable that will store the numeric value of the first fully empty row.