VBA syntax errors occur due to misspellings, typos and mistakes within the statement itself, such as not including all required arguments. VBA compile errors occur when VBA can’t compile the code.

Use this VBA error-handling routine to make sure no errors disrupt the code.