Where To Put Error Handling Code

[Tom]

Suppose you have code structure like this:
Option Explicit
Dim MyVariable As Single

Private Sub CallingProcedur e()
Call CalledProcedure ()
....Do This ...
End Sub

Private Sub CalledProcedure ()
....Do That ....
MyVariable = 5/0
End Sub

Obviously there is an error in the CalledProcedure . Where is recommended to
put the error handling code and why? In the calling procedure or in the
called procedure.

Thanks!

Tom

[rquintal]

>Obviously there is an error in the CalledProcedure . Where is recommended to

put the error handling code and why? In the calling procedure or in the
called procedure.

Both places is the place to put error handlers. In the called procedure
you should handle such things as missing variables, impossible values,
etc.

In the calling procedure, you put error handling to process things like
values out of range for the call, (sometimes a function call will
return a technically correct value that is out of range for your
calling procedure) etc.

In summary, handle errors at the lowest possible level, that way your
code is much more maintainable and transportable.

Q.