Search

Get Last Row And Column with Data

Articles

Use this function to get the address of the last row and column that has data.

Syntax

Get Last Row and Column with Data ()

Returns

Return value Description
Address Returns the address of the cell as row, column

Sample

Get Last Row And Column With Data ()

  • If last cell in sheet that has data is Row 27 and Column I,
    Returns 27,9 - the last row and column that has data.

To view all the Excel functions, click here.

Did you find what you were looking for?