Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Limit an GoTo Function command
I am writing VB code in Excel to reformat a number of Excel spreadsheets.
There's a section of the code where I have inserted an "On error GoTo Function" command to skip past a section of code if certain requirements are not met. However, if my code errors at any other place than in that one section, the code loops back to the error function. Is it possible to limit the section of code that the On Error GoTo Function so secondary errors don't llop back to the defined function? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Limit an GoTo Function command
Hi
Use code below to disable your Error Handler : On Error Goto 0 Regards, Per "lbsstacey" skrev i meddelelsen ... I am writing VB code in Excel to reformat a number of Excel spreadsheets. There's a section of the code where I have inserted an "On error GoTo Function" command to skip past a section of code if certain requirements are not met. However, if my code errors at any other place than in that one section, the code loops back to the error function. Is it possible to limit the section of code that the On Error GoTo Function so secondary errors don't llop back to the defined function? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
command code ( GOTO command) in formula | New Users to Excel | |||
Error with Goto command | Excel Programming | |||
USING A GOTO COMMAND IN EXCEL | Excel Worksheet Functions | |||
Goto Command in Code | Excel Programming | |||
search or goto command needed. | Excel Programming |