Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Error Handling
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 -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Error Handling
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 '------------------------------------------------------------- -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
handling calculated excel cell error messages | Excel Discussion (Misc queries) | |||
Handling #NUM! error | Excel Worksheet Functions | |||
Error handling | Excel Programming | |||
Error handling | Excel Programming | |||
Error Handling | Excel Programming |