I think we need to see more of the sub. With the bit of code you showed it
will always exit for. If it finds that one of the values in the array is in
B29 it will exit for. If it does not find that it will still exit for when it
has exhaused all the values in the array (it falls out at the bottom of the
loop.
I would suggest that when sending code you use copy and paste, rather than
retyping. Otherwise we tell you all your typos, which you should have found
in VB editor anyhow.