Address of Last used cell in Column "A" and Dynamic Named Range

[blbat]

Find the Address of Last used cell in Column "A" -using a formula only- whether numeric or text.

There will be NO blank cells between the beginning and end of the values in Column "A". The values may be numeric or text.

I know this:

=ADDRESS(MATCH(9.99999999999999E+307,A:A),1)
finds address of last numeric value, and that:

=ADDRESS(MATCH(REPT("z",255),A:A),1)
finds address of last text.

So I was trying to figure a way to find the addess of the last used cell in column "A" without regard to value type in the cell (numeric or text).

I thought about using a "IF(ISNUMBER( " statement such as:

=If(ISNUMBER(ADDRESS(MATCH(9.99999999999999E+307,A:A),1),ADDRESS(MATCH(9.99999999999999E+307,A:A),1),ADDRESS(MATCH(REPT("z",255),A:A),1)
but I get errors, I can't tell if my logic is flawed or my syntax is flawed.

My intent with the above statement is that If "ISNUMBER" is "TRUE" then give me the address, if "FALSE" then "ADDRESS(MATCH(REPT("z",255),A:A),1)" which would still give me the last address.

or is there a cleaner way?

 

[blbat]

Re: Address of Last used cell in Column "A" -using a formula only- whether numeric or text

Disregard previous post!

I was studying the site that VoG posted and figured out I need to put the scope equal to the workbook...NOT the sheet. (because I was invoking it from a different sheet)

I love this place.