Event Change VBA for dating changes

[wompwomp]

I have a sheet in a workbook that stores completed projects. I would like to add a date column to the end of the row when a project is moved to the 'Completed' sheet. This is what I have so far:

Please Login or Register  to view this content.

This works (as in, it dates the new rows). But instead of a single column for date, it adds eleven. The sheet has information in columns A to N, with N being the new date column I want this event change to add. This code adds a date to columns N to W. What can I do to return one date value to column N only?


Thanks!

[Paul]

If your date column is always going to be N, why not just specify that? I added an event disabling bit to stop any infinite loops, and used 'Not Intersect' to save the 'Exit Sub' from being needed as a separate line.

Please Login or Register  to view this content.

When you're copying data that includes, for example, columns G:M (7 columns), the pasted Target (changed cells) includes all of those cells, which is why it's putting a datestamp 13 columns to the right of each of those Target cells.

[wompwomp]

Thank you THANK YOU thank you! That worked perfectly! I appreciate your explanation for why it was creating so many date columns. I'm new to VBA and this helped me understand the logic.

You're the best Paul

[Paul]

You're welcome, glad to help!