$$Excel-Macros$$ Re: DateStamp Macro Debug Help

2009-07-17 Thread Dave Bonallack
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

$$Excel-Macros$$ Re: DateStamp Macro Debug Help

2009-07-17 Thread Norman May
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: