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?
 
G

Guest

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

Similar Threads

Macro conflict 4
Macro creation via VBA 26
Screen Updating 2
Problem in updating all worksheets of a workbook using a macro that calls another macro 3
Excel Macro Question? 2
menu bar and error 91 3
Problem with webquery in VBA 1
MACRO in a Loop Problem 2

Top