Hello everyone:
I was helped earliear by a couple of experts on date stamp. I was referred to a site to find the resources. The site used the code:
I was helped earliear by a couple of experts on date stamp. I was referred to a site to find the resources. The site used the code:
Code:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
With Target
If .Count > 1 Then Exit Sub
If Not Intersect(Range("e19:e32"), .Cells) Is Nothing Then
Application.EnableEvents = False
If IsEmpty(.Value) Then
.Offset(0, 1).ClearContents
Else
With .Offset(0, 1)
.NumberFormat = "dd mmm yyyy hh:mm:ss"
.Value = Now
End With
End If
Application.EnableEvents = True
End If
End With
End Sub [code/]
The problem is that cell e19:32 get their value from a formula. With this code it only works if I press enter after entering the value in one of the referencing cells. E19:E32 are dynamic cells that change based on formulas so the code needs to work on change not enter.
Any help?