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

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

no, i didn't. i'll see if i can make it work now.

thanks

--


Gary


"Tom Ogilvy" wrote in message
...
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