Get Last Empty Cell

Description

This Activity finds the last empty cell in a specific row or column of a selected spreadsheet and returns the corresponding cell address.

Properties

Input

• Spreadsheet – Specify the Excel Workbook instance to get the last empty Cell.
• Row Number – Specify the row number you want to get the last empty Cell.

  or

• Column Name – Specify the column name where you want to get the last empty Cell.

info

• To get the last empty Cell under column D inside a sheet, specify the column name value as "D".
• To get the last empty Cell inside row number 10 inside a sheet, specify the row number value as "10".

Misc

• DisplayName – Add a display name to your Activity.
• Private – By default, Activity will log the values of your properties inside your workflow. If private is selected, then it stops logging.

Optional

• Sheet Name - The spreadsheet name where you want to get the last empty Cell on row/column. By default, it operates on the currently active Spreadsheet.
• Continue On Error – It Specifies whether the automation should continue even when the Activity throws an error. If True, the Activity continues without throwing any exceptions. If False, the Activity throws an exception. The default value is False.

note

Catches no error if this Activity is present inside the Try-Catch block and the value of this property is True.

Output

• Cell Address - Returns the last empty cell in a specified Excel spreadsheet row or column.

Example

Download Example