[Solved] Hanging Excel after running a macro copied to another file

Question

Just had another look through you code and noticed that you define wb_zest as ActiveWorkbook and i am guessing this is where the above code resides.

You are then trying to close wb_zest, the problem here is the code can’t close the workbook that the current sub is running in.

As you stated the code used to reside somewhere else and is now in wb_zest so you would no longer need to close wb_zest.

Try removing this line altogether and see how it runs.

Hope this helps

Accepted Answer

Just had another look through you code and noticed that you define wb_zest as ActiveWorkbook and i am guessing this is where the above code resides.

You are then trying to close wb_zest, the problem here is the code can’t close the workbook that the current sub is running in.

As you stated the code used to reside somewhere else and is now in wb_zest so you would no longer need to close wb_zest.

Try removing this line altogether and see how it runs.

Hope this helps