count rows of recordset

masterphilch · Oct 22, 2005

Hi

Is it possible to count the rows of a RecordSet without stepping throug it?

greez
masterphil

Dnereb · Oct 22, 2005

Yes use the recordset propperty's:
.. movelast
..recordcount

to find the number of records. (instead of stepping you've jumped

)

Anne Troy · Oct 22, 2005

=count(a1:a20) will count numbers
=counta(a1:a20) will count all values
Or you can try the Subtotals feature, and use Count:
http://www.officearticles.com/excel/getting_subtotals_in_microsoft_excel.htm
************
Anne Troy
www.OfficeArticles.com