<div>
hi mutrus<br />
normally this would mean that somewhere in the procedure is a label called &quot;-1:&quot; (and that the code written below this label would be executed)<br />
Regards, Manfred
</div>


hi mutrus
normally this would mean that somewhere in the procedure is a label called "-1:" (and that the code written below this label would be executed)
Regards, Manfred

<div>
Hi mutrus<br />
It's not often I see the On Error GoTo -1 .......<br />
<br />
On Error Goto 0 clears the error handler. <br />
On Error Goto ?1 clears the current exception. It works pretty much like the Err.Clear statment.<br />
<br />
<br />
I hope this is of any help ....<br />
<br />
Peter
</div>


Hi mutrus
It's not often I see the On Error GoTo -1 .......

On Error Goto 0 clears the error handler.
On Error Goto ?1 clears the current exception. It works pretty much like the Err.Clear statment.


I hope this is of any help ....

Peter

<div>
Thanks Peter<br />
<br />
I thought as much but needed to be sure
</div>


Thanks Peter

I thought as much but needed to be sure

<div>
<div class="content wysiwyg-content">
I came across this code in a macro<br />
<br />
On Error GoTo -1: On Error GoTo EndDoc_<br />
<br />
I am familiar with what the On Error does but can someone tell me what the GoTo -1 statement does<br />
<br />
Thanks
</div>
</div>


I came across this code in a macro

On Error GoTo -1: On Error GoTo EndDoc_

I am familiar with what the On Error does but can someone tell me what the GoTo -1 statement does

Thanks

What is On Error GoTo -1

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.