Search

Get Last Cell with Data

Articles

Use this function to get the address of the last cell that has data.

Syntax

Get Last Cell with Data()

Returns

Return value Description
Address Returns the address of the cell

Sample

Get Last Cell with Data()

  • Gets the address of the last cell that has data.
    Returns Z25, the address of the last cell that has data.

To view all the Excel functions, click here.

Did you find what you were looking for?