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

Please Login or Register  to view this content.