Thread: Counting
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Counting

Hi,

I'm not to sure you've described the question fully but you could try this.
Alt +F11 to open VB editor. Double click 'This Workbook' and paste this in
on the right

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Range("A1").Value = ActiveSheet.UsedRange.Rows.Count
End Sub

Change A1 to wherever you want the count to be

Mike

"Reen" wrote:

Is there a way to automatically count the number of entries on the spreadsheet?
Meaning a running total of rows with data entered on it?