Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I'd like to get some ideas on error handling best practices. I prefer to handle the errors where they occur using something like this Set myWS = Nothing on error resume next Set myWS = ActiveWorkbook.Worksheets("Sheetabc") On Error goto 0 if not myWS is nothing then 'Do Stuff end if I've also seen On Error GoTo ErrHandler with the error handler at the end. I've been trying to update a workbook that has the latter and I'm finding it's a pain to find the errors without making other code changes. Ideas folks? Thanks, Barb Reinhardt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
First Error works but Subsequent Error Handling Does Not | Excel Programming | |||
Error handling error # 1004 Run-time error | Excel Programming | |||
Set Error handling INSIDE error-trap | Excel Programming | |||
Error Handling - On Error GoTo doesn't trap error successfully | Excel Programming | |||
Error handling with a handling routine | Excel Programming |