Hello all you geniuses. I have another VBA issue. I have built a sheet, and what I'm looking for is when anyone changes the date in column J (Last Update), it counts that as updated in cell F3 (Actions updated since last review). I have the VBA code as:
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Sheets("Sheet1").Range("J10:J136"), Target) Is Nothing Then
Range("F3").Value = Range("F3").Value + 1
End If
End Sub
However, what I'm realizing now is I need F3 to reset to 0 every time the worksheet is opened, so that it's only counting the current updates and doesn't continue to increase the count of total updates made.
Thanks in Advance
Bookmarks