View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default pause code while Query is refreshing, then continue

hi
i am guessing that you are allowing a background query. the code will pause
if you do not allow for the query to refresh in the back ground. not sure how
you are refreshing now but in my code i use something like this.....
sheets("sheet1").range("A1").querytable.refresh backgroundquery:=false
code will pause until the refresh is done.

Regards
FSt1
"Damian" wrote:

I have a worksheet that Needs to refresh its query and then run code, BUT my
problem is while it takes few seconds to refresh it the code runs and gives
me the result before query refresh.

How can I fix that?

Thank You