Results 1 to 9 of 9

Phantom Breakpoints Driving me insane!

Threaded View

  1. #1
    Registered User
    Join Date
    03-07-2013
    Location
    Long Beach, WA
    MS-Off Ver
    Excel 2013
    Posts
    87

    Phantom Breakpoints Driving me insane!

    This makes no sense to me:
    I am running a vba-based program to update a number of files.
    The code seems pretty simple, if not done with best practices .. as I got code suggestions from a number of places.

    Anyway, it was all working fine!!!!!
    So, I assume that the code was pretty much OK, eh?
    Then it would stop working.
    So then I would make changes to try to fix it.
    So, I can't say that I've made NO changes but no changes that I'd expect to have such drastic outcomes.
    And then only to fix the disruptions.

    As an outline:
    There is a summary file that has a list of all the data files.
    The objective is for the summary file to call the data files in sequence, have them get their respective updates and close, returning to the control of the summary file vba.

    Right now the outcome is that the summary file stops (with "Code execution has been interruped: Continue/End/Debug/Help")
    at an End If statement but will continue with either F8 or Continue.

    Then it stops with the same interruption again at the beginning of the next called workbook Private Sub Workbook_Open() statement.

    Selecting continue bounces between these two interrupts.
    Using CTRL-SHIFT-F9 seems to do nothing.

    This is very bad because I can't get code to just execute normally - except perhaps by accident. Then, again by apparent accident it stops working again with non-predicatble results.

    I have no idea how to proceed at this point.
    Last edited by fred3; 08-02-2014 at 11:14 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Sum row until criteria is met (driving me insane!)
    By Mbarnes in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-18-2012, 10:10 AM
  2. Breakpoints Ignored
    By Lord Fitzy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-02-2007, 07:49 PM
  3. Excel time formating driving me insane
    By White noise in forum Excel General
    Replies: 6
    Last Post: 12-09-2006, 09:15 PM
  4. Replies: 1
    Last Post: 10-20-2006, 07:00 PM
  5. Date&Time calculation driving me insane
    By jondyad1 in forum Excel General
    Replies: 1
    Last Post: 04-06-2005, 09:22 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