I have this code(below) and need to change the macro to run every time a cell in the macro changes its value.
Thanks
Option Explicit
Public dtmNext As Date
Sub Check4Update()
With Worksheets("Rep 21")
If .Range("A1").Value < Date Then
.Range("F14").Value =...