Last used row number and cell address, last numeric or text value in column

  Find Last Used Row in a Column:   Related Links: VBA Codes – Last used row; Last used column.   ———————————————————————————————————     Formula for ‘Cell Address of the last numeric value within column’   =ADDRESS(MATCH(9.99999999999999E+307, A:A), COLUMN(A1))  [Formula]   The formula returns cell address of the last numeric value in column, which is...

Scroll to top