If Then condition is False but code executes anyways

[terriertrip]

I have an If Then statement that's been working as it should, but all of sudden I'm having an issue with the condition.
I'm not really sure why this is running the code when FindRng is Nothing. I've debugged and an error is thrown. When I take the debug out, the If Then is True. How is this even possible? I've heard that Find can be buggy sometimes.

Please Login or Register  to view this content.

[Mumps1]

Try:

Please Login or Register  to view this content.

[terriertrip]

I should have clarified that the first If Then works correctly. The second If Then condition is False since 'blah' is not within the range being searched. VBA see's FindRng as Nothing, but then continues executing the code within the second If Then statement instead of seeing False and moving out of the condition. I've set the FindRng as an object. Do I need to review this? If I try and use <> "" on the second If Then condiiton, it doesn't like that which tells me something is different about FindRng vs. blah in regards to what type of object they are. It's been working fine up to a point, but all of a sudden decided to "ignore" the condition.

[Mumps1]

They should all be defined as "range" which they are. Can you post a copy of your file (de-sensitized if necessary) and explain in detail what you are trying to do referring to specific cells, rows, columns and sheets? See the yellow banner at the top of this page for instructions to attach a file.

[terriertrip]

I can't how unbelievably stupid I am. Too much overthinking of this. I just didn't have the Not in the second If Then statement. Somehow I must have removed it when fiddling with the code. Thanks for letting me bounce something off you.

Please Login or Register  to view this content.

[romperstomper]

This is not correct:

Please Login or Register  to view this content.

You're trying to set an object using a data value. It should be:

Please Login or Register  to view this content.