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.
|