How to run macro after PowerQuery refresh

[Will85]

Current code:

Sub Refresh()

ThisWorkbook.RefreshAll

Call Hide_Blank_Rows

End Sub


My issue is that its calling the Hide_Blank_Rows macro before the PowerQuery refresh is complete. I notice that it takes about 10 seconds from the time the refresh is initiated to the time it actually starts refreshing. Or, its refreshing so fast, but my sheets are taking a while to begin recalculating their values, that the Hide_Blank_Rows macro is run before the recalculation is complete. I cant tell if its the actual refresh or just the amount of time it takes for all my sheets to recalc.

 

[Fluff]

Duplicate to: Macro problem, refresh data and call other macro, call is happening before refresh is complete

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.