Hi Bob,

Many thanks for the thorough explantion. It is very clear.


Igbert


"Bob Phillips" wrote:

See http://www.xldynamic.com/source/xld.LastValue.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Fenneth" wrote in
message ...

Forgive me for these trivial questions, but I cant find the answer using
the documentation.

I want a formula to use the bottom non-blank cell in a range. How can
this be achieved?


--
Fenneth
------------------------------------------------------------------------
Fenneth's Profile:
http://www.excelforum.com/member.php...o&userid=33655
View this thread: http://www.excelforum.com/showthread...hreadid=534500