Excel waiting for one macro to finish before calling another
I'm using Application run to call several macros in order like this.
Sub Run_A开发者_开发知识库ll_Macros()
Application.Run ("Macro_1")
Application.Run ("Macro_1")
End Sub
When I start Run_All_Macros, all the macros run in parallel. Is there a way to wait for the first macro to complete before the second is started?
If you step through the macros (Use F8) you should see that they are running in order and not simultaneously.
I use the step through method to watch exactly what is happening and in what order. I often find I've included an error in logic, or something else, that doesn't give the desired result.
精彩评论