On Nov 11, 3:35*pm, "Otto Moehrbach"
wrote:
It's not a matter of before or after. *It's bracketing your action code with
the On Error code. *Before the code that you thing might error out, write
something like "On Error Resume Next". *With this line you have said "Don't
EVER stop on ANY error". *Obviously, you don't want that. *You just want to
trap the possible error within a small bit of your code. *After your code
has dealt with the error you want a line like "On Error GoTo 0". *That
returns the error detection system back to normal. *Does this help? *Otto

"Matthew Dyer" wrote in message

...



Could someone please give me a brief overview of how the 'on error'
code works? what different kinds of things can I do with it? Do I
place it before code that may return an error or after?- Hide quoted text -

- Show quoted text -

that acutally does help. I found a really good online tutorial for on
error coding written by chip pearson who you've probably seen around
these groups. I highly reccomend anyone who has any questions about on
error coding to check it out.
http://www.cpearson.com/excel/ErrorHandling.htm