Wait for refresh/calc before proceeding

F

Finny388

I have a sheet that uses an MS Query to pull data.
I also have a bunch of vlookups looking at that data.

In a vba procedure, I want to Refresh All, then hide some unused rows.

But I have to wait until the refresh and calc is finished to know what
rows will be unused.

How can halt the macro until the refresh and calc is done?

So far I just have:

Sub RefreshAll()
ActiveWorkbook.RefreshAll
<hide routine>
End Sub
 

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

vba code does not run 3
wait before executing rest of a macro 3
ComboBox.Enable giving error on ActiveWorkbook.RefreshAll 10
Refresh Query Table causing debug error with Background Refresh pr 2
query refresh question 3
Refresh VBA 1
Macro doesn't refresh 4
Wait until MSQuery Refresh finished 1

Top