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!