Thanks jim I will check it out.

"Jim Thomlinson" wrote:

Check out this link...

http://www.xldynamic.com/source/xld.LastValue.html
--
HTH...

Jim Thomlinson


"gwbdirect" wrote:

I need a formula that will show the last cell in a range.
1000
2000
3000

want to show 3000 as the result and not the total of everything in the
column!!!