Put Date in Cell B when value is inserted in C, D, or E.

http://www.excelforum.com/excel-gene...e-changes.html

I got the code in the above link working for me, but how would I restrict it to a certain subset of Rows? It's overwriting headers and totals and other things I don't want to change in the worksheet.

Thank you in advance for your help!

Starting with Row 2 and for now through Row 40. The Row subset will grow as they fill up.

I updated the target to include three columns (C, D, & E) and I updated the offset to (0,-1) with the hope that it would put the date in column B. It's not quite working out as hoped. Right now it works perfectly if I enter a value in Cell C (date autofills in Cell B), but if I put a value in Cell D, Cell C gets the date, and if I put the value in Cell E, Cell D gets the date. I only want Cell B to have a date in it, no matter if the value is entered in Cell C, D, or E. How do I represent the offset so that Cell B always gets the date?

Thanks!

Please Login or Register  to view this content.

If there was a way to get the same effect via formulas in the cells instead of a "worksheet event" as the original coder described it, I'd be really into it. It seems like that would be a more nuanced approach.

The "B" designation doesn't work (no dates appear anywhere when any cells are updated). Thanks for the try.

Right click on tab, "View Code" and then pasting it in the box that shows up. Box has "Worksheet" in top left and "Change" in top right. I copied your code verbatim and overwrote the code I had in there.

...and now when I copy my code back in and save, it doesn't work either! Yikes, what did I do? The file is saved as macro-enabled.

Okay, I got it working, including your code. Now how to restrict the target to a certain section of Rows?

Starting with Row 2 and for now through Row 40. The Row subset will grow as they fill up.

Thank you for your help!