View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
JMay JMay is offline
external usenet poster
 
Posts: 422
Default 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?