Date stamp in absolute column

Ok, I've got a sheet with lots of columns. Each time someone makes a change in any row of any one of those columns, I want it to date stamp it in an extra column on the end so we always know who made the last change to each row and when. The actual entering of the data isn't a problem, the problem I'm having is getting it to always put the data stamp in the right column or row.

The code I've got is :-

Please Login or Register  to view this content.

Which is great if the user presses Enter after typing, but if they press the left or right arrows, the datestamp appears one cell to the left or right of where it's supposed to be. I'm sure it's simple to make it an absolute column but it's doing my head in.

Thanks!

Assuming you're using the Worksheet_Change event and you want the date to go in say column J use:

Please Login or Register  to view this content.

As Target is a range you can use that as your reference point rather than ActiveCell which as you say may well have changed from Target.