Time Stamp a change in Cell

[archieross123]

Hi there,

The following code works well if i want to time stamp a change in a cell in one column.

However, it doesn't work if i want to time stamp a change in a cell in multiple columns in a sheet.

For example, if i change the data in a cell in column 2 it time stamps in column 3, change data in column 4 it time stamps in column 5 etc etc.

If someone could please help with this, that would be appreciated.

cheers,

[AlphaFrog]

Please Login or Register  to view this content.

[archieross123]

that works really well thanks,

I only want the time stamp to apply within cells A1:BE500. I don't want it to apply to cells outside of this range.

can you please help with this.

thanks,

[AlphaFrog]

Please Login or Register  to view this content.

[archieross123]

thank you Alpha Frog