How do I do incorporate an "if statement" with the ".find" method in a range?

[max3732]

I want to search the selected range for a variable value (calculated previously in the sub) and if it finds the value I want the sub to do some things. If it's not in the range I want it do something else.

Here is the relevant section for what I have:

Please Login or Register  to view this content.

This works and cuts the value I'm looking for if it finds a value in the range. The problem is it's not in the range I don't know how to tell it to follow other instructions. I tried the "iserror" with an in statement, but it said the range was not set. Intellisense isn't working and I don't really know how to use the .find method

[stnkynts]

Please Login or Register  to view this content.

The above is incorrect. You have not specified a range to find "income" in. You would need to change it to something like this:

Please Login or Register  to view this content.

[max3732]

There is no way to tell it to search for the selected range? So I should take out

Please Login or Register  to view this content.

and replace it with:

Please Login or Register  to view this content.

I tried that and I get a type mismatch error

Then I can I say something like:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

The above is incorrect. You have not specified a range to find "income" in. You would need to change it to something like this:

Please Login or Register  to view this content.

[stnkynts]

A range value doesn't return true or false. It is either a range or nothing. To test the validity of .find you would do something like this:

Please Login or Register  to view this content.

However, I doubt this will answer your question. The code you supplied is pretty garbled. I would suggest you submit a clearer and precise picture of what you are trying to accomplish and having us rewrite from scratch. Submitting an example workbook with before and after examples will help you get a solution faster.