+ Reply to Thread
Results 1 to 3 of 3

Why Does Macro End After Formatting

  1. #1
    Forum Contributor
    Join Date
    09-06-2012
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    225

    Why Does Macro End After Formatting

    Instead of moving on to the next tab and continuing the rest of the macro, the sub exits after this portion of the macro. After this section, I have the same exact thing, only with different worksheets in the same workbook. Does anyone see something that could be causing it to stop the sub?



    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    09-06-2012
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    225

    Re: Why Does Macro End After Formatting

    Wow...nevermind, I completely forgot that I had the 'If xxx = "" then exit sub' criteria.

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,995

    Re: Why Does Macro End After Formatting

    The only thing that can cause a Sub to exit in the middle is an error being raised, or the statement Exit Sub. If you were getting an error you would see the dialog box pop up. That only leaves one possibility. See below.

    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/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