OK, here is your problem. As I mentioned above, if you have the following formula in B6
=B8
a change to B6 will not trigger the Worksheet_Change event, but a change to B8 will. Your Worksheet_Change code checks to see if the Target is B6, but it will never be true in your scenario. You need to test for
or any other cells that the formula in B6 refers to. If the formula is not simply an "=" then you can do this:
and so forth. So you look for a change in B8 to trigger the event, but you look at the value of B6 to figure out what you need to do.
Bookmarks