Err.Number 0 with No Err.Description

[Elana]

I have a procedure where my error handler simply states msgbox err.number & " " & err.description.

On running the particular procedure today, I received the msgbox stating only "0". No description of the error. Obviously something is wrong, but I don't know what.

Any suggestions?

 

[Travis]

Before your ErrorEvent tag is there an Exit Sub or Exit Function.

What is most likely happening is that your code is running fine and then running your error message because there is no Exit prior to it.

 

[Elana]

That was it! Thanks for the prompt response!