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