count total number of rows of data in excel

• • Reply

  14 years ago

  by kwwm

  karen mcavoy

  , United States

  Joined 14 years ago

  I need to write a macro that will tell me the total number of rows of data, through a variable name, that are on the worksheet.  Anybody?

   

  Report abuse
• • Reply

  14 years ago

  by Kassem

  Kassem Baalbaki

  Riyadh, Saudi Arabia

  Joined 14 years ago

  Hi,

  I understand that you want to count the number of records in an excel sheet. If so use the following code assuming that the first record is in the cell A1:

      Dim Count As Integer
      Range("a1").Select
     
          Range(Selection, Selection.End(xlDown)).Select
     
      Count = Selection.Cells.Count
     
      Range("a1").Select
  
  
  
  
  
  
  
  
  

  Hope this works for you.

  Report abuse