This modified code seems to work
Public Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
'Application.EnableEvents = False
On Error GoTo Errorhandler
Target.Offset.Offset(0, 13) = Now()
'Application.EnableEvents = True
End If
Hi,
I pasted your code into my XL2000. I don't get any error when inserting rows.
Dave.
Date: Fri, 17 Jul 2009 12:36:21 -0700
Subject: $$Excel-Macros$$ DateStamp Macro Debug Help
From: pogs...@gmail.com
To: excel-macros@googlegroups.com
Hey all,
I found a very simple macro to track