Skip to main content

Find Last Empty Row And Column

Description​

This Activity finds the last empty Row and Column in the specified range inside the selected sheet.

info

An empty row or column is where all the cells of that row or column are empty.

note

This Activity works only inside Google Context activity.

Properties​

Location​

Misc​

  • DisplayName – Add a display name to your Activity.
  • Private – Logs the variable and argument values at the Verbose level when unchecked.

Optional​

  • Range - Specify the range to find the last empty row and column within the range. By default, the range is the entire sheet.
  • Sheet Name - Specify the sheet's name where you want to find the last empty Row and Column. By default, it operates on the first sheet.
  • Continue On Error – Specifies if the automation should continue even when the Activity throws an error. This field only supports Boolean values (True, False). 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​

  • Row Number - Returns the last empty row's number.
  • Column Name - Returns the last empty column's name.

Example​

Download Example

Find Last Empty Row and Column