"MikeZz" wrote in message
...

So "Target" is just the range, not the values in the range? By your
comment,
I'd assume that the "Intersect" is not checking the values to the range in
the code, just checking to see if the the changed range is part of the
compared range?

That's correct. Target is a range object, to get the values you have to use
the Value property (and the Cells property if it is a multi-cell range).

Your other assumeoption re Intersect is also correct, and that is how you
stop the code executing for any change, you can control it to execute just
for your specified range, or even take different actions depending upon
which which range the changed cell is part of.