VBA Code - IfError Help

[wolfdemon710]

Hi,

I have a vlookup formula in my vba code, and it basically goes through a array checking all accounts. But right now, it crashes if an account in present in the vlookup.

I am basically looking to run the vba and if it finds a #NA, instead of shutting code, it should keep running and saving all the vlookup values in an array that gave the error.

For example,
Vlookup runs to find account number 123, then it goes to the next account number 124 but its not in the list, instead of crashing I want the another array save this account number and go to the next account number.

Please Login or Register  to view this content.

[Norie]

Put the result of the Vlookup in a variant variable, then use IsError to check that variable before doing anything else.

Please Login or Register  to view this content.

[wolfdemon710]

Hi,

I get an error at RES=Application.Vlooklip ...... Run-Time Error 13, type mismatch

[Norie]

How did you declare Res?

[jolivanes]

Change the "lip" to "Up" in Vlooklip