On Error, Restart Function

  • You could use the GoTo command .... or .... you could simply recalll the Function.


    Something like :


  • You can clear the error first, then call the function. However, this is an unusual thing to do. I'm following to see how you make out.



    Methods

    With Err Object there are two methods that you can also use.

    • Err.Clear: This method clears the error number and error description from VBA’s memory (It’s different from “On Error GoTo -1” as it doesn’t completely reset the error).


Participate now!

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