how to calculate with vba the number of records in an excel- table?
Hi, thanks for replying.
My problem is that i never know the range.
Suppose table "mydata" with the fieldrow in A5:F5 and the real records from
A6:F6. But the number of records will be different each time (those records
are coming from an external source).
So i need something like counting the rows of "mytable", but without using a
given range because it varies each time.
Thanks
"vezerid" schreef in bericht
oups.com...
One way (using worksheet function):
Dim NumRec as Long
....
NumRec =
Application.WorksheetFunction.COUNTA(Sheets("Data" ).Range("A:A"))
HTH
Kostis Vezerides
André wrote:
Hi,
I need the number of records in a table, and i need it into a variable in
VBA.
Thanks again
Britt
|