I've been searching for a solution to a problem for a little while now. I have a macro which switches between 2 workbooks, pasting in an account number to the second which then updates the data through SQL when done manually. The problem is when I do this through VBA code, the data doesn't refresh even though it at first appears to (in that the timer starts and says updating, then stops but doesn't actually change the figures). I have tried a line of code to "pause" the macro for 10 seconds, and I've tried a ".RefreshAll" line but neither work for me. Any help would be very much appreciated. Thanks.