View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
L. Howard Kittle L. Howard Kittle is offline
external usenet poster
 
Posts: 698
Default Count cell changes

Maybe something like this change-event macro

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
Range("L36").Value = Range("L36").Value + 1
Application.EnableEvents = True
End Sub

HTH
Regards,
Howard

"Rod" wrote in message
...
I'm new to macros. I need to count the cell changes in G4 and sequentially
count them in cell L36. Any help would be greatley appreciated.