find the last cell in that range with data

What is the data type? Is it TEXT or NUMERIC or is it a mixture of BOTH? Are
there any formulas in this range that return blanks? Do you want to include
these blanks as data?

Assuming the data type is TEXT and there are no formulas in the range that
return blanks:

=IF(COUNTA(D18:V18),ADDRESS(18,MATCH(REPT("z",255) ,D18:V18)+3,4),"")


--
Biff
Microsoft Excel MVP


"sevi61" wrote in message
...
Hi,

I have scoured these posts but haven't quite found what I'm looking for,
hopefully someone can help....

Is it possible to write a formula that will search a range (D18:V18), find
the last cell in that range with data, then show the cell address, not the
value of the cell, in a different cell? I have been thinking that maybe I
will need an array formula, or at worst, a macro or VBA?

Any response will be greatly appreciated.

sevi