I am watching a number of named ranges on one sheet and want to try make my code a simple as possible.
Each named range I am watching corresponds to a day of the month so it can be up to 31 named ranges.
I have the following working for one range
If Not Intersect(Target, Range("day_1")) Is...