Thread: On Error ??
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default On Error ??

On error goto ErrHandler

' code to cause an error


ErrHandler:
' code to write log

Resume Next
End Sub

--
Regards,
Tom Ogilvy

"Kevin" wrote in message
...
Can you have an On Error Goto ErrHandle and then once it is done handling

the error resume from where the error occured.

Example would be that I am copying several files to different

workstations. It can't copy the file to the workstation because it is not
running. This would be the error. It would then goto an error ahndle where
it write this information to a log. I then want it to continue from the
point that error occured.

TIA