I am trying to create a macro that will run only when selected values in a sheet are manually modified. Currently, I have a private sub linked to the relevant worksheet, which detects change in the following fashion:
As you will have guessed, I have a problem because this macro runs whenever I manually enter a change but also when the VBA coding changes the target cells. And since the macro triggered by change to the target range also includes further changes to the target range, it runs continually and I need to stop it using Ctl + break.
Could anyone help me either find a way to differentiate between manual and automatic (i.e. VBA) change, or provide me with a different macro that will run only once if a value in the target range is changed?
Thank you very much for your time and help!