Automatically update date when a range of data is changed

It works fine for me but then again I haven't seen the rest of your code.
If you share some more info it should be no problem making it work. Delete things you don't want to share from your workbook and post it with just some sample data.
Or just post more of the code.

Does this work for you?

Note that the code is located in a Sheet module. Note also the "Worksheet" and "Change" in the dropdown menus. This setting will give you a Sub with the title

Please Login or Register  to view this content.

Any time a cell is changed on that worksheet this Sub will run and the cell that was changed will be available in the Target variable.
The IF setting just makes sure the code only runs if the Target cell is before the "J" column and after the first row.Code in sheet module, Worksheet Change.PNG

If you right click on a tab and choose Show Code, you will come directly here.

Almost forgot to put the code on display as well

Please Login or Register  to view this content.