Take a look at VBA's help for "On Error". You'll see this:

Enables an error-handling routine and specifies the location of the routine
within a procedure...

So you're off to some place within that same procedure.


Maybe you could use:

Option Explicit
Sub yoursub()

On Error GoTo ThisProcedureErrorHandling:

'your code here

Exit Sub 'avoid the error handler


ThisProcedureErrorHandling:
Call error_h
'or
'Call error_handling.error_h
Resume Next '???
End Sub

and in the error_handling module:

Option Explicit
Sub error_h()
MsgBox Err.Number
Err.Clear
End Sub



"Pierre via OfficeKB.com" wrote:

Hi tom,

i now have:

- a workbook open sub in which the first line should be : on error goto
error_h

error_h() is in the module error_handling

ho can i get the on error goto routine to start error_h in module
error_handling ?

When i try my code i get the message:
"name not defined"

Thanks,
Pierre

Tom Ogilvy wrote:
You can run Sub's or Function's. Modules contain Sub's and Function's

Hi norman,

[quoted text clipped - 19 lines]
Any ideas?
ThanksPierre

--
Message posted via http://www.officekb.com

--

Dave Peterson