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?
Per Jessen - 18 Apr 2008 13:44 GMT
Hi
Use code below to disable your Error Handler :
On Error Goto 0
Regards,
Per
>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
[quoted text clipped - 6 lines]
> Function
> so secondary errors don't llop back to the defined function?