Make VBA code wait until table refresh is complete

[CharBram]

Hello everyone,

I have some VBA code that refreshes all data tables (from SQL server) before it starts a for loop that loops through all the workbooks and then does some stuff.

How can I make VBA wait until the tables are all refreshed before it moves into the loop and starts changing things on the sheets?

 

[JoeMo]

Is there something that produces an indication that the refreshes are complete?

 

[Nothnless]

Is there something that produces an indication that the refreshes are complete?

How would you indicate this?