bluefish44
Board Regular
- Joined
- Apr 3, 2009
- Messages
- 190
I have two macros which I have strung together into 1 long macro.
The first macro refreshes a bunch of sheets with Power query.
The second macro populates cells with formulas and drags down the formulas next to the updated queries.
When I run 1 macro, wait for it to finish and then run the second, things work fine.
Problem is, when I combine them into 1 long macr,o the 2nd part begins dragging my formulas down before the queries are completed refreshing.
Is the a way to delay the second part of the macro from starting until the entire refresh of the power query is complete?
Thanks in advance
The first macro refreshes a bunch of sheets with Power query.
The second macro populates cells with formulas and drags down the formulas next to the updated queries.
When I run 1 macro, wait for it to finish and then run the second, things work fine.
Problem is, when I combine them into 1 long macr,o the 2nd part begins dragging my formulas down before the queries are completed refreshing.
Is the a way to delay the second part of the macro from starting until the entire refresh of the power query is complete?
Thanks in advance