+ Reply to Thread
Results 1 to 3 of 3

Debugging problem

  1. #1
    Registered User
    Join Date
    01-19-2007
    Posts
    17

    Debugging problem

    I'm trying to step through one of our macros written forever ago. Everytime a Range is used in the code the debugging process skips to this function "instring." Then the Step Into just starts an infinite loop inside the function. It is getting really annoying.

    How can I stop this?

    If I run the code normally it works fine.

  2. #2
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    It would be much easier to assist you if we could see the code you are working with. Consider pasting a copy of your code here (using the code tags), or post a .zip copy of the workbook.

  3. #3
    Registered User
    Join Date
    01-19-2007
    Posts
    17
    OK I figured it out. They wrote a custom function to use in the cell formulas to return a boolean if a certain text is instring.

    Everytime a cell in the range uses the function I get stuck in the loop instead of it moving to the next line in the sub.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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