+ Reply to Thread
Results 1 to 2 of 2

Error handling

  1. #1
    Registered User
    Join Date
    09-19-2011
    Location
    oc,ca
    MS-Off Ver
    Excel 2003
    Posts
    44

    Error handling

    When I execute the code below the first time, the div by 0 error that occurred in sub f1 causes sub f1 to be executed again. However, vba will break and display an error message when sub f1 is executed again. Why? is there a way to prevent the vba from breaking and just keep on executing f1?

    Please Login or Register  to view this content.
    Last edited by david90; 08-04-2013 at 09:11 PM.

  2. #2
    Forum Contributor
    Join Date
    01-02-2007
    Location
    Australia NSW
    MS-Off Ver
    2013
    Posts
    494

    Re: Error handling

    Are you not able to rectify the code so that any error is handled correctly, then you do not need to handle the error in the first instance?

+ 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. Error Handling: Can it report line # where error occurred?
    By PingPing in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-20-2010, 03:47 AM
  2. Error handling for error that occurs frequently
    By adyan76 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-15-2010, 02:50 PM
  3. On Error Goto (Global Error Handling)
    By mpeplow in forum Excel General
    Replies: 3
    Last Post: 04-10-2007, 11:33 PM
  4. [SOLVED] Error Handling - On Error GoTo doesn't trap error successfully
    By David in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-16-2006, 02:10 PM
  5. Error handling with a handling routine
    By ben in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-15-2005, 11:06 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