Throwing an error ... on purpose!

  • Thread starter Thread starter Sarah B via OfficeKB.com
  • Start date Start date
S

Sarah B via OfficeKB.com

Background:
I have been learning to use error handling when coding macros - mostly just
using On Error GoTo statements. I have a subroutine that is called from an
OnError GoTo block. If a certain condition is met (no files were found that
fit my criteria), I want my subroutine to throw an error and return to the
function that called it. This is not a situation that will normally throw an
error, but I need to handle it as if it were an error.

Question:
How do I throw an error? (short of simply putting in a non-valid statement
that I know will cause a real error)
 
Just add the line

Error 1

Which raises the application defined or object defined error. For different
errors just use the appropriate error number/code.
 
Thanks! I've had to rearrange my code and now I don't need to purposely throw
an error. But I will keep this command handy just in case.
 
Back
Top