Date Stamp On Worksheet Change

Hi all,

I have the following little piece of code that adds the date to C3 whenever the workbook is saved:

Please Login or Register  to view this content.

Can anyone advise on how (if it is at all possible) to only run this code when someone changes a cell value (in particular the cells in range A7:AY186 and A189:AY216)?

TIA,

SamuelT

Good afternoon SamuellT

Originally Posted by SamuelT

Can anyone advise on how (if it is at all possible) to only run this code when someone changes a cell value (in particular the cells in range A7:AY186 and A189:AY216)?

You mean run the instant it changes, and doesn't check on saving? If so, something like this should help :

Please Login or Register  to view this content.

HTH

DominicB