ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Count cell changes (https://www.excelbanter.com/excel-discussion-misc-queries/261039-count-cell-changes.html)

Rod

Count cell changes
 
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.

L. Howard Kittle

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.





All times are GMT +1. The time now is 10:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com