Macro that writes date when a change is made.

[gr507105]

Hi everyone, Im new here great to join this forum :D

Im having issues while trying to make this macro work.

Basically what I need is that every change made on a sheet record the date in the same sheet, there are several sheets and I wanted to isolate the macro to record the date to the modificated sheet.
That's not the behavior I got, everytime any sheet gets modificated it change the entire sheets date.

Please Login or Register  to view this content.

This macro is located in module #1

Please Login or Register  to view this content.

thanks in advance!!!!

[HaHoBe]

Hi, gr507105,

please mind to wrap your code posted here with code-tags.

Code goes behind the sheet to monitor (no extra code in a module needed):

Please Login or Register  to view this content.

Ciao,
Holger