Macro conflict

Z

zapper

I have a macro that consists of 2 macros.

Sub Macro3 ()
Macro1
Macro2
End Sub

Both Macro1 and Macro2 operate on the same area
of the worksheet.
I want Macro2 to run after Macro1 has completed.
They appear to be running concurrently and I'm
getting the wrong result.
How do I force Macro1 to finish before Macro2 kicks in?
 
T

Tom Ogilvy

they don't run concurrently unless macro1 kicks off an asynchronous process.
For example, If macro1 is doing a querytable update or something, then make
sure you set the BackgroundQuery property to false.

Also, make sure calculation is set to automatic if that is a consideration.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top