+ Reply to Thread
Results 1 to 6 of 6

macro doesn't complete all steps

  1. #1
    Registered User
    Join Date
    01-05-2012
    Location
    toronto, canada
    MS-Off Ver
    Excel 2003
    Posts
    13

    macro doesn't complete all steps

    I have a macro which also calls two other macros within it.
    It is not executing part of the code but when I use the step through process (F8) it executes everything properly
    Why would the macro perform differently when I execute it compared to when I step through it?

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: macro doesn't complete all steps

    My guess would be, you have select and active sheets/range, somewhere in your code. This depends on where the cursor is. You may also have end with statement where you may have omitted a dot in one of the lines.
    Last edited by AB33; 10-31-2013 at 08:19 AM.

  3. #3
    Registered User
    Join Date
    09-24-2013
    Location
    Poland
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: macro doesn't complete all steps

    Sometimes it could be in events. But why? I don/t know.

  4. #4
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: macro doesn't complete all steps

    Hudibyk,
    Yes, you are right.
    If you have a range reference in the code, this could trigger an event code, but I am not sure if this also happens if you run the code with out stepping over, as one can not see it.

  5. #5
    Registered User
    Join Date
    01-05-2012
    Location
    toronto, canada
    MS-Off Ver
    Excel 2003
    Posts
    13

    Re: macro doesn't complete all steps

    Here is the macro. I included the two small macros which are usually called by this macro.
    Please note the steps missed when it is run (about 3/4 down)
    Last edited by Capcel; 10-31-2013 at 03:59 PM.

  6. #6
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: macro doesn't complete all steps

    Capcel,
    Please use code tags with your code as per forum's rule.
    With out tags, the code fills up, almost the page.

+ 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. Office 2010 macro error - Not all steps recreated in macro - Help!
    By duffer in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-21-2011, 01:33 PM
  2. Macro - hiding the steps?
    By Koda7 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-17-2010, 02:27 PM
  3. 1st Steps to learning VBA/Macro's
    By Tictac in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-21-2010, 07:35 PM
  4. Do not show a macro's steps
    By Andrew-Mark in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-15-2009, 10:49 AM
  5. Macro that steps, but won't run!
    By qdog in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-22-2007, 12:20 PM

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