The simplest way is
=counta(A1:A65536)
--
Alex Delamain
------------------------------------------------------------------------
Alex Delamain's Profile:
http://www.excelforum.com/member.php...o&userid=11273
View this thread:
http://www.excelforum.com/showthread...hreadid=274579