Hi,
Is there a way for a macro to be not active when trying to insert a row or a way to have the macro understand that it's just a row shift? I'm trying to have a time stamp that anyone changes the value in a column. The following code generates an error 1004: application or object defined error when I insert or delete a row
Private Sub Worksheet_Change(ByVal Target As Range)
Dim cell As Range
If Not Intersect(Target, Range("F1:F2000")) Is Nothing Then
For Each cell In Target
cell.Offset(0, -1) = Format(Now(), "mm/dd/yy HH MM AMPM")
Next cell
End If
End Sub
Bookmarks