I have multiple SQL queries in a VBA macro. Then run one after another in a loop based on pulling in different values from an array. I need to make the macro pause before proceeding so that the data can be refreshed. I've seen multiple posts on disabling the background refresh outside of VBA, but I need to do it within a loop in VBA. How do I do this?