Since there can be alternatives in what you want check this website:
http://www.xldynamic.com/source/xld.LastValue.html

Does that help?

***********
Regards,
Ron


"amrezzat" wrote:


Heloo

if i have 1 and it is so long say may be more than 1000 rows

1
2
3
453
566
4465
352
2
3434


how can i get the last number in it??
although each cell is a formual not blank


--
amrezzat
------------------------------------------------------------------------
amrezzat's Profile: http://www.excelforum.com/member.php...o&userid=28766
View this thread: http://www.excelforum.com/showthread...hreadid=487323