Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
handling calculated excel cell error messages RK Excel Discussion (Misc queries) 2 October 22nd 07 01:05 PM
Handling #NUM! error Michel Khennafi Excel Worksheet Functions 1 February 26th 07 08:49 PM
Error handling Tim C Excel Programming 1 October 7th 03 10:00 PM
Error handling John Pierce Excel Programming 3 October 3rd 03 12:17 PM
Error Handling Bill Lunney Excel Programming 0 August 6th 03 11:56 PM


All times are GMT +1. The time now is 09:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"