Excel Error Handling

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
 
B

BrianB

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
'-------------------------------------------------------------
 
Top