Run Macro When Formula Result Changes in multiple ranges

Hello,

I found this forum thread:
excelforum.com/excel-programming-vba-macros/1008582-run-macro-when-formula-result-changes.html

I got the code as they describe it (see code below).

Now i like to use this code for multiple ranges, but i dont know how.

My ranges are:
- ("G92,HH92")
- ("G103,HH103")
- ("G114,HH114")

if its possible i like to use named ranges (dynamic ranges)

Simply said: If a certain range is changed, a cell needs to get value =1. Not for 1 range but for multiple ranges.

Please Login or Register  to view this content.

Untested, try to add all ranges:

Please Login or Register  to view this content.