You can count how many cells in a column contain numbers using =COUNT(A:A),
and how many cells contain anything using =COUNTA(A:A)
*******************
~Anne Troy

www.OfficeArticles.com


"blurboiboi" wrote
in message ...

Hi... is there any way I can determine the number of rows used using
formula instead of macro?...

The number of rows would constantly be increasing...


--
blurboiboi
------------------------------------------------------------------------
blurboiboi's Profile:
http://www.excelforum.com/member.php...o&userid=25183
View this thread: http://www.excelforum.com/showthread...hreadid=386724