View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
vezerid vezerid is offline
external usenet poster
 
Posts: 751
Default 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