Thread: Macro for Counting the number of records in a worksheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
jetted[_8_] jetted[_8_] is offline
external usenet poster
  
Posts: 1
Default Macro for Counting the number of records in a worksheet

hi

Assuming the data is in column A

Sub test()
rowcount = Cells(Cells.Rows.Count, "a").End(xlUp).Row
MsgBox rowcount
End Sub


--
jetted
------------------------------------------------------------------------
jetted's Profile: http://www.excelforum.com/member.php...o&userid=17532
View this thread: http://www.excelforum.com/showthread...hreadid=558896

Reply With QuoteReply With Quote