| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
reset "on error resume next"
I have a section of code that I want to use "on error resume next" to
bypass certain errors but then I want to restore the code to using the normal error function without using an error handling routine (just getting the visual basic popup stating that an run-time error occurred). How can I do that? Thanks. Edward |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
reset "on error resume next"
Restore default error checking with this statement:
ON ERROR GOTO 0 (Not especially Intuitive) Does that help? *********** Regards, Ron XL2002, WinXP "Edward" wrote: I have a section of code that I want to use "on error resume next" to bypass certain errors but then I want to restore the code to using the normal error function without using an error handling routine (just getting the visual basic popup stating that an run-time error occurred). How can I do that? Thanks. Edward |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
reset "on error resume next"
On Jun 30, 1:24 pm, Ron Coderre
wrote: Restore default error checking with this statement: ON ERROR GOTO 0 (Not especially Intuitive) Does that help? *********** Yes. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Where does an "On error resume next" statement apply? | Excel Programming | |||
| "on error resume next" NOT working... | Excel Programming | |||
| how to stop "On error resume next" ? | Excel Programming | |||
| Problem with "On error resume next" with "custom VLookup" | Excel Programming | |||
| "On Error Resume Next" Question | Excel Programming | |||
Linear Mode
