Is it possible to emulate a ten-key entry in Excel?
Thanks JE,
So when I see:
On Error GoTo 0
End If
End If
End With
End Sub
Isn't it (the On Error GoTo 0 line) sort of inconsequential
To disable error checking when there is only
End If
End If
End With
End Sub
AND also because, with the End Sub - the default error Checking is
"turned-back-on" for the next procedure?
Thanks,
Jim
"JE McGimpsey" wrote in message
:
One reference you should always check:
From XL/VBA Help ("On Error Statement"):
On Error GoTo 0 disables error handling in the current procedure. It
doesn't specify line 0 as the start of the error-handling code, even
if the procedure contains a line numbered 0. Without an On Error GoTo
0 statement, an error handler is automatically disabled when a
procedure is exited.
In article , "JMay" wrote:
JE -- The reference books I have are not clear on the meaning or use
of
On Error GoTo 0 -- can you clarify what it does?
|