Macro running other macros does not fully execute

[gle]

Hello,

I am attempting to run a macro which executes a couple of different macros in each of a bunch of worksheets in one workbook. It repeats the below for Sheet1, Sheet2, etc.

Please Login or Register  to view this content.

Unfortunately, it only seems to run through the first three lines of that code and only for the fist iteration, i.e. on "Sheet1", and then it stops. No error or anything like that.

I've looked around a bunch, and I've tried line by line execution, removing the SHIFT key from my shortcut command, removing certain sections, and so on. If I remove the first iteration of the code, it will then run through the first three steps on "Sheet2" and then stop. If it's relevant, the sheets are not actually named "Sheet1", "Sheet2", etc., I just edited the code above.

Any ideas? Thanks for the help!

[AlphaFrog]

One suggestion is there's something within Macro2 halting code execution.

[gle]

Great, that makes sense. Thanks for responding!

EndSub shouldn't do that, should it? The reason I would say that is because both Macro1 and Macro2 end with EndSub, so it doesn't seem like that could be it.

Let me know if anything here is unclear. The code of Macro2 for your perusal:

Please Login or Register  to view this content.

[JosephP]

remove the 'End' statement and replace it with 'Exit Sub'

'End' should never be used by itself

[gle]

Aha, that makes sense. (Checking...) That's glorious. Thanks so much to both of you!