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
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
Errorhandler: