Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |