try
application.enableevents=false
code
application.enableevents=true

--
Don Guillett
SalesAid Software

"andym" wrote in message
oups.com...
Dear All,

this seems like a common problem, but I have not seen a definiate
solution yet - so any help would be most appreciated.

I have some code that does a vlookup where the source data is via a web
query. Occassionally I need to refresh the web query to update the
data.

However, it appears that the code completes before the page is
refreshed, so the old data is still used in the vlookup.

When I manually step through the process (F8) it completes perfectly as
I presume the extra time I take enables the web query to refresh in
time.

Any ideas how I can ensure that the refreshing is completed before the
remainder of the code is finalised?

Regards,

andym