Search

Get Last Row with Data

Articles

Use this function to get the last row that has data.

Syntax

Get Last Row with Data ()

Returns

Return value Description
Address Returns the address of the row as a number

Sample

Get Last Row with Data () => 1

  • Gets the address of the last row that has data. Example: 1 for row 1, 12 for row 12 etc.

To view all the Excel functions, click here.

Did you find what you were looking for?