David Evans
Active Member
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("M9:M84")) Is Nothing Then Exit Sub
Range("B2").Value = Now()
Range("B2").NumberFormat = "mm/dd/yyyy hh:mm:ss"
End Sub
I want the value in B2 to be updated anytime a value in Range("M9:M84") changes. This range is updated from formula and not by the user making changes. My 'update" appears to only work if I edit one of the cells in the range ....
Any ideas Folks?