If NOT Error

[ScabbyDog]

I have a macro which looks for a certain word. If it finds the word it deletes all rows above it. If it does not find the word I have it to go to ErrorHandle which calls a macro that looks for a different word to find. I want it so that if the macro finds the word and deletes the rows above it that it calls an entirely different macro, and therefore doesn't have to go through the other macros looking for various words. Possible?

[stnkynts]

Sure. After you run the line of code that deletes the rows, call the other macro then exit the sub. If you were to supply your code we could give you an exact answer.

[ScabbyDog]

Please Login or Register  to view this content.

[ScabbyDog]

Thanks! Will test now.

[protonLeah]

Please Login or Register  to view this content.

[ScabbyDog]

Thanks proton. How would I adjust my code above to make it work? I think I'm hitting a snag or two.

[ScabbyDog]

Would it be this then?

Please Login or Register  to view this content.

[protonLeah]

Please Login or Register  to view this content.

[ScabbyDog]

If it doesnt find the word I want it to call test2. If it fimds the word and deletes it I want to call macro3. What you have above does not do that

[protonLeah]

Well, we are just guessing at what your code looks like. I just used "test2" because you used that in post #7. In the code posted in #8 note that I changed the variable type to Variant vs. Range.

The SET line will try to find *interest*; if it does, the variable is set to the range where the item was found, if *interest* is not RngFind is set to "NOTHING".
Notice RngFind can be either NOTHING or the location where the data was found. To test for a FOUND condition use:

If Not rngFind Is Nothing Then

The code in the If..Then block only executes if the value is found, else it does nothing at all. Thus if macro 3 is to be run when found simply replace test2 with macro3.

Now, if you want to execute an alternative macro when *interest* is not found, just add an ELSE block, thus:

Please Login or Register  to view this content.

[ScabbyDog]

Thanks Pronto! Works just as I want now. How would I finally adjust your code so it only searches the first 70 rows?

[protonLeah]

The quickest way, use:

Please Login or Register  to view this content.

I don't know which columns you actually want to search; I just used all cells from A1 down to Z70 as an example.