I have a macro where i use RefreshAll to refresh a currency table from the web. I then copy these values to other cells in the same code. The problem however is the values copy before the RefreshAll has completed.
Can anyone think how I can have the background query finish before moving on to the rest of the code.