Bart Friederichs wrote:
Andrew Douglas Pitonyak wrote:
Do you check in an error handler? I assume that you are NOT using
something like "on error resume next", and also, that you have not
used a resume command explicitly.
Here is my code:
Sub Main
[... snip..]
On Error Goto ErrorHandler
[.. snip, where an error might occur ..]
Exit Sub
ErrorHandler:
MsgBox "Error " & Err & " at processing sheet (line " & Erl & "): " &
Error$
End Sub
Does not look like you reset the error... Do you know what error does
occur? Does it seem to work with something like this?
Sub TestError
On Error Goto ErrorHandler
Dim x As Integer
Dim y As Integer
y = 0
x = 10 / y
Exit Sub
ErrorHandler:
MsgBox "Error " & Err & " at processing sheet (line " & Erl & "): " & Error$
End Sub
This works just fine for me.
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info: http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
