Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    May 2005
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    isolate code to stay in module (Excel 2000)

    Hello loungers,

    I am seeking help on a macro.

    I have a macro which run fine, but while I debug it, I find that the code wonders into another module which has a function in it and runs the code for that.

    Is there a way to only focus on the code in 1 module?

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: isolate code to stay in module (Excel 2000)

    Look at the Debug menu for the shortcuts available to you. F8 will execute a macro step by step, stepping into other code as it is called. Shift+F8 will execute a macro step by step, but step over other code (i.e. an external procedure or function is run as a single step). If you stepped into an external procedure or function by accident, you can step out of it by pressing Ctrl+Shift+F8.

Posting Permissions

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