+ Reply to Thread
Results 1 to 4 of 4

Error Handler Runs Without Error

  1. #1
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127

    Error Handler Runs Without Error

    I have written a long bit of code, which works fine. I decided to add an error handler just in case of any errors. I have run through my code numerous times to confirm that there is no error, but the msgbox still pops up. Any ideas/suggestions?

    Please Login or Register  to view this content.
    Last edited by BigBas; 10-03-2008 at 05:05 PM.

  2. #2
    Registered User
    Join Date
    01-09-2007
    Posts
    59
    Add an Exit Sub just above your ErrorHandler

    ska

  3. #3
    Valued Forum Contributor Richard Schollar's Avatar
    Join Date
    05-23-2006
    Location
    Hampshire UK
    MS-Off Ver
    Excel 2002
    Posts
    1,264
    Hi

    You need an:

    Please Login or Register  to view this content.
    before the error handler line

    Richard

  4. #4
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    It worked. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Run-time Error 9 with Excel macro - Runs in 2003, Fails in 2007
    By jialant in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-05-2008, 09:37 AM
  2. Error in 2003 - Runs OK in 2007
    By wz4np1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-27-2008, 09:48 AM
  3. Error #48 "Error in loading DLL" when new Add-in runs
    By batman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-04-2007, 12:22 AM
  4. Error Handling using Getdata
    By Climbo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-30-2007, 08:41 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1