View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default query after refresh question

did you instantiate the event?

http://support.microsoft.com/default...b;en-us;182735
XL97: How to Use the Query Before and AfterRefresh Events

--
Regards,
Tom Ogilvy



"Gary Keramidas" wrote:

inherited a workbook that runs a query when the date in cell B2 is changed. the
query was set up manually, no code.

i tried a QueryTable_AfterRefresh on the sheet the query exists, but it didn't
fire.

is there a way to tell when the query is finished?


--


Gary