Counting the number of rows

[blurboiboi]

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

The number of rows would constantly be increasing..

 

[Anne Troy]

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