VBA - If value not found, skip part of macro.

**crayhons** · 06-12-2013, 09:36 AM

Hi all,

What I'm looking to do:

-Search an external workbook for the word "Salary"
-IF "Salary" is not found I need to skip the part of my code that would reference where salary is found
-IF "Salary" is found, continue on normally with the code

If I need to explain more, I'd love to.

Thanks.

**Sean Thomas** · 06-12-2013, 09:54 AM

Hi ideally you should split the macros up

Please Login or Register  to view this content.

or you can use the goto statement but this is throwned upon

Please Login or Register  to view this content.

**crayhons** · 06-12-2013, 11:35 AM

Hi Sean,

I'm sure I really follow you.

I need the macro to search the workbook Census Tester for the value "Salary". If the macro doesn't find "Salary", it will skip the part of my macro that pulls salary data. If the macro does find "Salary", it goes on normally.

Thanks.

**Sean Thomas** · 06-13-2013, 08:31 AM

Hi,
thats what the above format does!
It was just a demonstration to show that you can split your macro up into sections and then call each section depending on if Salary is found.
Or you can leave as one macro but use the goto statement to jump to a certain part of your macro.

If you were to upload a workbook with your macro in, or at least upload your macro i might be able to help more.