[QUOTE=jk64;2541506]I need a function that records the number of times a cell in a worksheet has a value change.
QUOTE]
If you put in the following VBA code into the appropriate worksheet you should get what you're after:
![]()
Private Sub Worksheet_Change(ByVal Target As Range) If Target = Range("J5") Then Range("K5") = Range("K5") + 1 End Sub
Bookmarks