Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Handling
On Error Goto 0 will simply turn off custom error trapping. You have two
other choices: 1 - On error resume next - Will continue execution at the next statement regardless of errors 2 - On Error Goto errUnknown - Will jump to the line errUnknown upon an error. E.g. On Error Goto ErrUnknown DummyVal = 15/0 ' Will raise a divide by 0 error Exit Sub ErrUnknown: msgbox Err.Description -- Regards, Bill Lunney www.billlunney.com "Bin" wrote in message ... Is there anyway in Vb Program to use a code to override Error Trapping setting in VB/Tools/Option? If the setting is "Break on All Error", program error handling statement will not work. I tried to use "On Error Goto 0" to override it, but it doesn't work. Anyone can help? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error Handling | Excel Discussion (Misc queries) | |||
Error handling problem | Excel Discussion (Misc queries) | |||
Error Handling works only once | Excel Discussion (Misc queries) | |||
Handling #NUM! error | Excel Worksheet Functions | |||
Error Handling for "my" menu bar | Excel Discussion (Misc queries) |