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

sub Firstpart()
if salary found then
   macro1
else
   macro2
end if
End sub

Sub Macro1()
do what ever
then call next macro
Macro2
End sub

Sub Macro2()
do what ever
End sub

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

Sub Trythis()
    if salary found then
        'allow code to continue
    else
       goto otherpart
    end if

    Put code here for whatever you will do if salary found
otherpart:
    put code here for what to do when salary not found (this will also be used for the part where salary is found)
End sub

**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.