View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
gocush[_29_] gocush[_29_] is offline
external usenet poster
 
Posts: 252
Default Is there a "generic" Error Handling method

Of course everyone has there own but you could use something like:

On Error GoTo ErrorHandler

'Your code

'''''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''
'' Close and tidy up
Tidy:

'' Reset variables
Set cnn = Nothing
Set cmd = Nothing
ActiveSheet.Protect
Application.EnableEvents= True
' etc --- comment out the ones that don't apply
Exit Sub

'' - - - - - - - - - - - - - - - - - - - - - - - - - - - -
ErrorHandler:

MSG ="Error Number: " & Err & _
Chr(10) & "Error Description: " & Error()

MsgBox NSG, vbInformation, "ERROR:"
GoTo Tidy

End Sub

"Brad K." wrote:

Is there an Error Handling method that can be used in a generic sense? i.e.
a statement that can be included in any sub. that will handle any error to
some degree.

Thanks,
Brad K