Have you set
.BackgroundQuery=False
This should delay actions until the querytable has been updated.




wrote in message
ups.com...
I am programming excel to reterieve query tables as users select from
a drop down. That works fine.

I did have to use an OnTime function to delay calling the next
function while the query populates the table. Inconvenient, but not a
problem

However, When I try to make this available using a Summary Macro,
calling the procedures in another sub obviusly does not pause the
original Macro,

1) is there a way to pause and resume after a called macro is
finished?

(I want to the function, get the tables to populate and come back to
the original For Next Loop)

2) Instead of Call MySub, can you get a call command to reference a
cell with the Application.Run "'" & Range("X2") & "'" command.

This works, s ok if no. But I need it to pause until Range("X2") is
complete, which includes the user kicking of sql calls .onAction fom a
dropdown

I would paste code, but there is alot and my question is hopefully
easy. Everything works, just not sequentially