Solved

trapping runr time error

Posted on 1999-01-13
2
156 Views
Last Modified: 2010-05-03
I am getting a run time error 424, object not found. I want to get rid of that by making the system to execute next like  resume next. How can I do that.
0
Comment
Question by:lesa
  • 2
2 Comments
 
LVL 3

Accepted Solution

by:
traygreen earned 10 total points
ID: 1456036
Find out where the error is occurring - to lock it down - go through the code and place break points where you think it is occurring.  Then test.  Move the breakpoints according to wether the error occurs before or after the error.  When you find where the error is being raised, check to see if there is any error trapping in place.  If not include the code
On Error Resume Next
0
 
LVL 3

Expert Comment

by:traygreen
ID: 1456037
If there is error trapping in place...
Go to the error label and make sure that there is a select case err.number block.  In the select statement place the item case 424 with a resume next
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
VBS file using code from 2nd file (txt or vbs) 4 47
Copy a row 12 68
How to incorporate an error traping routing to existing code in VB6 11 48
Automatic Email Reminder 4 70
Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

680 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question