Macro conflict

  • Thread starter Thread starter zapper
  • Start date Start date
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?
 
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.
 
Back
Top