View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Michael Hopwood Michael Hopwood is offline
external usenet poster
 
Posts: 37
Default On Error Resume Next

If a line of code is encountered that causes an error, "On Error Resume
Next" will not process that line of code but will resume execution on the
following line.

"On Error Resume Next" is quite handy if you want to handle errors "in-line"
rather than running a sub and ending the procedu


On Error Resume Next
'Some line of code that returns an error here
If err.number = ErrorCodeToCheckFor then
'Do some stuff to handle the error
err.clear


--
Michael Hopwood (Phobos)


"Mike" wrote in message
...
I have seen "On Error Resume Next" in several different
macros but do not fully understand how it works. Any help
would be greatly appreciated. Thanks