I have a spread sheet that has multiple query tables across multiple sheets. I'v written a worksheet change sub that is is supposed to refresh all the data in the different tables, and then copy a certain range of data from one of the query tables and paste it on another sheet.
But every time I run the code, I keep getting an run-time error when the macro tries to select the data in the query table after the refresh.
Anyone know how I can fix this problem?
Run-time Error '1004'
Select method of Range Class Failed