how to calculate with vba the number of records in an excel- table?
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
|