Error Handling Confused

  • Hi All,

    I have a vlookup that worked previously but today didn't get up to there because of an error.

    I used the below initially to capture and control the error:

    Err.Clear didn't seem to clear the error. My vlookup would return a 1004 error.

    Luckily I found On Error Goto -1.

    This then fixed it. I'm confused because I'm used to having Err.Clear working, but in this case it didn't.

    My vlookup does have:

    On Error Resume Next preceeding the vlookup

    Any ideas?

  • Re: Error Handling Confused

    You should structure your code like so:

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!