Excel Error Handling

  • Thread starter Thread starter brutalmetal
  • Start date Start date
B

brutalmetal

Hi!
I am writing some VB code to generate a report from a pivot table dat
in an excel sheet.

I am looking for some error handling code or atleast a good listing o
error numbers and their descriptions. Can you please help me with it
 
There is lots of info around on this, including VB Editor help
See On Error, Err, Error etc. This code is copied from there whic
could give you a listing of all error codes using a wider range o
numbers:-


'-------------------------------------------------------------
Dim ErrorNumber
For ErrorNumber = 61 To 64 ' Loop through values 61 - 64.
Debug.Print Error(ErrorNumber) ' Print error to Debug window.
Next ErrorNumber
'-------------------------------------------------------------
 
Back
Top