+ Reply to Thread
Results 1 to 7 of 7

Debugging issue with Step Into

  1. #1
    Registered User
    Join Date
    10-10-2008
    Location
    Illinois
    MS-Off Ver
    Microsoft Office Excel 2003
    Posts
    85

    Debugging issue with Step Into

    Today I tried using F8 to step through my project and it was going sooo slow. I use F8 all the time and it usually zips right through I dont know if some option was changed or what. If anyone has any suggestions please let me know. Thank you.

  2. #2
    Registered User
    Join Date
    06-30-2009
    Location
    Southern California, Earth
    MS-Off Ver
    Excel 2010
    Posts
    72

    Re: Debugging issue with Step Into

    You can try setting break points (F9) at various points in your code instead of stepping. Then when you find your problem you can step in that area.

    Not sure what you mean by going slow, but if you have a lot of lines a break point is a great way of getting there quick and then stepping..

  3. #3
    Registered User
    Join Date
    10-10-2008
    Location
    Illinois
    MS-Off Ver
    Microsoft Office Excel 2003
    Posts
    85

    Re: Debugging issue with Step Into

    what i mean by going slow is that if you hold down F8 it will process like 30 rows a sec. but mine is only doing 3 lines a sec. when I hold it down

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Debugging issue with Step Into

    Depending on what the code is, the workbook may be recalculating between every step, the code may be talking to the printer driver, ...
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Registered User
    Join Date
    06-30-2009
    Location
    Southern California, Earth
    MS-Off Ver
    Excel 2010
    Posts
    72

    Re: Debugging issue with Step Into

    From what SHG says, you might try setting the recalculate mode to manual?

    At the beginning of your macro:
    Please Login or Register  to view this content.
    at the end:
    Please Login or Register  to view this content.
    Not sure if you it will affect your macro though.

  6. #6
    Registered User
    Join Date
    10-10-2008
    Location
    Illinois
    MS-Off Ver
    Microsoft Office Excel 2003
    Posts
    85

    Re: Debugging issue with Step Into

    I does not seem to matter what the code is. I threw together a quick (endless) loop statement to see how fast and how many times it would loop in (lets say 5) Seconds. Usually it would be impossible to count but mine will only do 4 loops

  7. #7
    Registered User
    Join Date
    06-30-2009
    Location
    Southern California, Earth
    MS-Off Ver
    Excel 2010
    Posts
    72

    Re: Debugging issue with Step Into

    Hey Chip, did you try restarting your computer 3 times?

    Just kidding, not sure what the issue is here. Google CCleaner, maybe your computer is bogged down with old temp files. That is all I can think of if this is occurring even on a pretty much empty workbook with just a few lines of code.

+ 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