I wrote a macro and I want to run it automatically if one special cell change but have problem, because contents cell change by formula in other cell and user must not change any cell, therefore result of formula change in cell but macro not run?!
copy your code here and you can select it from VBA windows by selecting desired Sheet then on right side window from drop down menu select Worksheet instead of General and from other drop down select Calculate
Private Sub Worksheet_Calculate(ByVal Target As Range)
Was this answer helpful?Thanks for your feedback.
Don't forget to take a few seconds to say thanks: Thanks for your feedback.
We're sorry. Our aim is to give you the best possible answer.