I've got a macro which runs on 12 worksheets.
When the result of a formula changes I want the macro to do his job.
What I do now is manually selecting each worksheet and then copy-paste a formula in the same cell.
For the copy-paste action I've made a macro. The macro will copy-paste a formule in the same cell for each of the 12 sheets. But I still need to select the sheet before my initial macro is activated.
I've searched the internet and I found something which may clearify my issue:
How do I run a macro every time a certain cell changes its value?
There is an event called Worksheet_Change which is triggered when a value is entered (it will not fire when a formula result changes).
What's between the brackets is exactly what I want: Fire the macro when a formula result changes.
Does anybody know how to do this?