Why oh why won't this work?????
I use this all the time, so what can cause the problem here. BTW I get the Application-Defined or Object-Defined Error (1004).
Could it be that the Refrsh isn't finished when exceuting an other macro??? I use the DoEvents commandline after I exceute the refresh-macro. Shouldn't this force the macro to finish before it continues???
Code:
Sheets("DATA1").Select
Range("A2").Select
Selection.QueryTable.Refresh BackgroundQuery:=False
Could it be that the Refrsh isn't finished when exceuting an other macro??? I use the DoEvents commandline after I exceute the refresh-macro. Shouldn't this force the macro to finish before it continues???