Why Does Macro End After Formatting

[Gard5096]

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.

[Gard5096]

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

[6StringJazzer]

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.