Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 - error saving file & error loading dll | Excel Discussion (Misc queries) | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
Syntax Error Runtime Error '424' Object Required | Excel Programming |